Subject & Section: CTINFMGL - COM231
Professor: 👩 Jensen A. Santillan
No. of Units: 3 Units
Prerequisite: CCDATRCL - Data Structure and Algorithm
Course Repo: CTINFMGL - INFORMATION MANAGEMENT
A flight booking web application designed to simplify the process of booking flights with the used of modern JavaScript techstacks
Overview The Flight Booking App is a web application designed to simplify the process of booking flights for users. The app allows users to search for flights, book tickets, manage their itineraries, and make payments seamlessly. The app also includes an admin panel for managing flights, users, and payments. The goal is to provide a user-friendly, efficient, and secure platform for flight bookings.
🚀 1. User Authentication: Users can create accounts, log in, and manage their profiles.
🚀 2. Flight Search: Users can search for flights based on destination, departure time, and other criteria.
🚀 3. Booking Management: Users can book flights, view their bookings, and cancel or modify them.
🚀 4. Payment Integration: Secure payment gateway integration for processing payments.
🚀 5. Admin Panel: Admins can manage flights, users, and payments.
- Frontend: React.js (JavaScript framework)
- Backend: Node.js with Express.js (Node.js framework)
- Database: MySQL for flexible use of SQL
- Authentication: JWT (JSON Web Tokens)
- Payment Gateway: Stripe or PayPal ( Not required!) we use local host authmanagement
- Email: Brevo API
- State Management: Redux or Context API
- Styling: CSS-in-JS (Styled-components) or Tailwind CSS
- Deployment: Vercel (for Next.js) or Heroku or Dokploy
https://dokploy.com/#pricing)
Run npm install to to install node modules Also you direct already to frontend folder and run npm start
npm install
Direct to frontend folder after you install the node modules
cd frontend
npm start
Open another terminal in the current codebase to run nodejs for VS Code or other IDE base on what you are using such as Webstorm
cd backend
node index.js
Connect MySQL dbs through Database repository folder
See Database folder above
sql
INSERT INTO `flights` (departure_city, arrival_city, flight_date, duration_hours, base_price, flight_status) VALUES
('New York', 'London', '2024-11-10', 7, 500.00, 'Full'),
('Los Angeles', 'Paris', '2024-11-11', 10, 900.00, 'Available');
INSERT INTO `users` (username, password_hash, role, email, phone_number) VALUES
('akosidogi', '$2b$10$yFTXogxecYrNSRLvFMb.dej4A4snSkHF72ZLItUjwrDFT16tlHCvK', 'admin', 'admin@example.com', '1234567890');
INSERT INTO `carts` (flight_id, user_id) VALUES
(1, 1);
INSERT INTO `seats` (flight_id, seat_number, class, status, seat_price) VALUES
(1, '1A', 'Economy', 'Available', 100.00),
(1, '1B', 'Economy', 'Booked', 100.00);
INSERT INTO `flight_names` (flight_id, region, name) VALUES
(1, 'Europe', 'Transatlantic Express');
Description Coming Soon
Entity Attribute Value Model will be uploaded in this section file after 💥 Myckle Vince fininish the Normalization
Full Overview of Normalization is in the Folder of documentation
CTINFMGL_FINAL_PROJECT/
│
├── LICENSE
├── README.md
├── assets
│ ├── Cloud Architecture.png
│ ├── ERD Airline Reservation.jpg
│ ├── Entity Relationship Diagram - ALA.png
│ ├── Entity Relationship Diagram.png
│ ├── Flight Booking ERD DRAFT V2.png
│ ├── Flight Booking ERD Scratch .jpg
│ ├── Flow Chart.png
│ ├── Front Page.png
│ ├── Prof Jensen Project Consultation.jpg
│ ├── Search Flight 2.png
│ ├── Search Flight.png
│ ├── Sequence Diagram.png
│ ├── Table of Content.jpg
│ └── Video Page.png
├── backend
│ ├── auth
│ │ ├── adminAuth.js
│ │ └── userAuth.js
│ ├── config
│ │ ├── emailConfig.js
│ │ └── mutlerConfig.js
│ ├── controller
│ │ ├── cartController.js
│ │ ├── chatbotController.js
│ │ ├── emailController.js
│ │ ├── flightController.js
│ │ ├── seatController.js
│ │ └── userController.js
│ ├── database
│ │ └── Mysql.js
│ ├── index.js
│ ├── package-lock.json
│ ├── package.json
│ ├── routes
│ │ ├── cart.js
│ │ ├── chatbot.js
│ │ ├── email.js
│ │ ├── flights.js
│ │ ├── seat.js
│ │ └── user.js
│ ├── services
│ │ ├── cartService.js
│ │ ├── chatbotService.js
│ │ ├── emailService.js
│ │ ├── flightService.js
│ │ ├── seatService.js
│ │ └── userService.js
│ └── views
│ └── index.ejs
├── database
│ ├── carts_table.sql
│ ├── flight_names.sql
│ ├── flights_table.sql
│ ├── seats_table.sql
│ └── users_table.sql
├── documentation
│ ├── Normalization.pdf
│ └── images
│ ├── Normalization SS-1.png
│ ├── Normalization SS-2.png
│ └── Normalization SS-3.png
└── frontend
├── package-lock.json
├── package.json
├── public
│ ├── _redirects
│ ├── favicon.ico
│ ├── index.html
│ ├── manifest.json
│ └── robots.txt
└── src
├── App.css
├── App.js
├── App.test.js
├── apicalls
│ ├── emailAPICALL.js
│ └── seatAPICALL.js
├── components
│ ├── Admin-Add
│ │ ├── Admin_Add.css
│ │ └── Admin_Add.jsx
│ ├── Admin_Nav
│ │ ├── Admin_Nav.css
│ │ └── Admin_Nav.jsx
│ ├── Card
│ │ ├── Card.css
│ │ └── Card.jsx
│ ├── ChatBot
│ │ ├── Chatbot.css
│ │ └── Chatbot.jsx
│ ├── Checkout
│ │ ├── Checkout.css
│ │ └── Checkout.jsx
│ ├── FlightMap
│ │ ├── Flightmap.css
│ │ └── Flightmap.jsx
│ ├── Footer
│ │ ├── Footer.css
│ │ └── Footer.jsx
│ ├── ForgotPassword
│ │ └── ForgotPassword.jsx
│ ├── Nav
│ │ ├── Nav.css
│ │ └── Nav.jsx
│ ├── Search
│ │ ├── Search.css
│ │ └── Search.jsx
│ ├── Timeout
│ │ └── Session_Timeout.jsx
│ ├── Video
│ │ ├── Video.css
│ │ └── Video.jsx
│ ├── Welcome
│ │ ├── Welcome.css
│ │ └── Welcome.jsx
│ └── myFlights
│ ├── MyFlight.css
│ └── MyFlights.jsx
├── images
│ ├── berlin.png
│ ├── eye.svg
│ ├── github.svg
│ ├── gmail.svg
│ ├── hawaiiWelcome.jpg
│ ├── linkedin.svg
│ ├── live-chat.svg
│ ├── my-location.svg
│ ├── newyork.png
│ ├── paris.png
│ ├── password.svg
│ ├── philippineTrip - Trim.mp4
│ ├── philippineTrip.mp4
│ ├── philippinesWelcome.jpg
│ └── x-symbol.svg
├── index.css
├── index.js
├── logo.svg
├── pages
│ ├── Admin
│ │ ├── Admin.css
│ │ └── Admin.jsx
│ ├── Cart
│ │ ├── Cart.css
│ │ └── Cart.jsx
│ ├── Main
│ │ ├── Main.css
│ │ └── Main.jsx
│ ├── Profile
│ │ ├── Profile.css
│ │ └── Profile.jsx
│ ├── Register
│ │ ├── Register.css
│ │ └── Register.jsx
│ └── SignIn
│ ├── SignIn.css
│ └── SignIn.jsx
├── password.svg
├── reportWebVitals.js
├── setupTests.js
└── utilities
├── ScrollTop.js
└── scroll.js
If you would like to contribute to the Flight Booking App, please follow these steps:
- Fork the repository.
- Create a new branch for your feature or bug fix.
- Make your changes and commit them.
- Push your changes to your forked repository.
- Submit a pull request to the main repository.
🧠 Contributions are welcome! If you have ideas for improvements or want to add more exercises, follow these steps:
- Fork the repository.
- Create a new branch.
- Make your changes and commit them.
- Push to your fork and submit a pull request. 💕💕💕💕
-
😎 Jay Arre Talosig - Machine Learning Engineer | Blockchain Developer | Bioinformatics Scientist
-
🧭 Custer Valencerina - Machine Learning Engineer | Full Stack Engineer | Front-End Developer
-
💥 Myckle Vince Natividad - Cybersecurity Forensic Engineer | Cloud Security Architect | Cyber Defense Forensic Analyst | Cybersecurity Scrum Master
-
🎲 Angelo Castillo - Network Security Engineer | Machine Learning Engineer | Security Forensic Analyst
-
🤖 Neo Flores - Machine Learning Engineer | Network Engineer | DevOps Engineer
-
🌟 Yeshua Venezuela - Cyber Intelligence Specialist | Software Engineer | UI / UX Designer | Digital Forensic Analyst
Some changes need to be address
- Fix Bug in the Frontend
- Fix Bug in the Backend
- CRUD operation management in SQL WorkbenchComing Soon In the License tab
The National University of Manila License grants permission to students of the National University of Manila to use, modify, and distribute this project for educational purposes within the scope of their coursework and assignments.
- You may use this project as a reference or learning material for your studies at the National University of Manila.
- You may modify the project to suit your educational needs and requirements.
- You may share the project with your fellow students or instructors for educational purposes.
- You may not use this project for commercial purposes.
- You may not redistribute or publish this project outside the National University of Manila without explicit permission.
This project is provided "as is" without warranty of any kind, express or implied. The National University of Manila and the project contributors disclaim any liability or responsibility for any direct, indirect, incidental, special, exemplary, or consequential damages arising out of the use or misuse of this project.
Professor Mrs. Jensen Santillan is a highly respected academic and industry practitioner. Her expertise spans a wide range of areas, including Data Analytics, Data Science, Data Analysis, Data Structures, and Information Management. As a distinguished faculty member at the College of Computing and Information Technology at National University, she shares her knowledge and skills with students.
Your dedication to advancing knowledge in this field and your commitment to educating future professionals have been invaluable. Thank you for your guidance, support, and the wealth of information you have shared. Your efforts have greatly enriched this final project and will undoubtedly have a lasting impact on all who engage with this repository.
Chronological list of updates, bug fixes, new features, and other modifications for our Flight Booking Appplication.
- 💻 Final Project requirements for our project
- ✨ Create a repository for this Flight Booking App
- ✨ Brainstorming for our Project requirements
- ✨ Jay Arre Talosig 💻 🚀 will be in-charge for Frontend Development & Technology stacks
- ✨ Jay Arre Talosig 🧠 🔑 will be in-charge for Backend Development & Entity Relationship Diagram
- ✨ Custer Valencerina 🧭 🧭 will be in-charge for SQL and debugging for backend, API and documentation
- ✨ Myckle Vince Natividad 💥 💥 will be also in-charge for SQL, Backend, documentation and Normalization
- ✨ Angelo Castillo 🎲🎲 will be in-charge for creating Entity Attributes View (EAV)
- ✨ Neo Flores 🤖🤖 will be in-charge for creating the overall documentation of the Project
- ✨ Yeshua Venezuela 🌟🌟 will be in-charge for suggesting a good design in the Frontend User Interface
- ✨ Brainstorming on what database should we use
- ✨ Custer Valencerina Uploaded a schematic ERD Diagram from scratch and based on Draw.io
- ✨ Angelo Castillo, Myckle Vince Natividad, Neo Flores revise the EAV model
- ✨ Uploaded the EAV model
- ✨ Jay Arre Talosig Fixed Node modules for Flight Booking Client source codebase
- ✨ Angelo Castillo Fixed the EAV
- ✨ Myckle Vince Natividad Revise the Normalization table
- ✨ Revise the Entity Attributes View model
- ✨ Yeshua Venezuela created a proof-of-concept design for our Front-end UI design.
- ✨ Jay Arre Talosig successfully added the FrontEnd (Client) for our Flight Booking
- ✨ Myckle Vince Natividad , Custer Valencerina Fixed the attributes for EAV and Normalization
- ✨ Jay Arre Talosig Revise the Backend and database
- ✨ Jay Arre Talosig Revise the Entity Relationship Diagram
- ✨ Jay Arre Talosig Uploaded ERD
- ✨ Jay Arre Talosig Uploaded the Screenshot for Flight Booking
- ✨ Push the Front-end folder
- ✨ Jay Arre Talosig Update Changelogs for Flight Booking
- ✨ Custer Valencerina added a constructive comment for a specific function in the frontend (client-side)
- ✨ Myckle Vince Natividad added a constructive comment for a specific function in the backend (server-side)
- ✨ Neo Flores successfully created the Entity Attributes View
- ✨ Angelo Castillo created the first draft of the overall documentation
- ✨ Myckle Vince Natividad successfully created the Normalization
- ✨ Jay Arre Talosig Uploaded Normalization in the documenation folder
- ✨ Thesis Project Deliveration for CTINFMGL - INFORMATION MANAGEMENT
- ✨ Custer Valencerina successfully created a codebase for a integration in Brevo API for Email using node.js
- ✨ Jay Arre Talosig revise the folder tree structure
🧊 Flight Booking Application
