CST 336 - Internet Programming
Provides students with dynamic web application development skills, focusing on the PHP, MySQL, and JavaScript. Coverage includes the Internet architecture, XHTML, CSS, programming with PHP, database and MySQL, and client-side programming with JavaScript.
Flight Ticketing System
Description
Landing Gear is a simple ticketing system for booking flights. The system allows both users and admins to search for flights using an additive filter where each field narrows the search criteria to make finding the desired flight easier. There are two sides to the system:
User
Our customers have the ability to create a login, search for available flights, and book flights adding a number of seats. Users will also be able to browse the flights they have booked, and cancel them. On the reservations page, the user can also see the total number of seats booked (sum quantity of seats reserved).
We have created a basic user with the “username/password” credentials for testing. There are a number of users created in the website with pre-populated data. For those dummy users, the username and password are the same (i.e. johndoe/johndoe)
Admin
The system also has an admin panel with a basic functionality. Admins can view and search all flights as users do. However, they also have the ability to schedule, update and delete flights. A default admin has been created using the credentials “admin/secret”. Additionally, they have access to three reports that provide deep insight into the system:
User
Our customers have the ability to create a login, search for available flights, and book flights adding a number of seats. Users will also be able to browse the flights they have booked, and cancel them. On the reservations page, the user can also see the total number of seats booked (sum quantity of seats reserved).
We have created a basic user with the “username/password” credentials for testing. There are a number of users created in the website with pre-populated data. For those dummy users, the username and password are the same (i.e. johndoe/johndoe)
Admin
The system also has an admin panel with a basic functionality. Admins can view and search all flights as users do. However, they also have the ability to schedule, update and delete flights. A default admin has been created using the credentials “admin/secret”. Additionally, they have access to three reports that provide deep insight into the system:
- Airport Transit Breakdown: Provides the usage analytics of each airport as either a destination or origin of flights. Admins can then understand what airports have the most air traffic and passenger traffic.
- User Reservations Breakdown: This report provides insight into user reservation patterns. It allows the admin to understand learn both their Whales and Frequent Flyer behaviors. Then target those users for incentive programs, exemptions, corporate accounts, etc.
- Flight Inventory Breakdown: Generates a report of flight popularity. Displays the number of flights scheduled, their capacity and booking average. Admins can then make decisions on what flights can be removed, or where more flights would be beneficial for the business.
Technologies
- NodeJS
- MySQL for database storage
- EJS as the templating system
- HTML and CCS
- JQuery for async ajax calls