In-Flight Services

• 

  Toilet Reservations

• 

  Landing Page

• 

  Order Confirmation

• 

  Food Order

Inspiration

We have all faced the challenge of getting up to use the restroom on the plane, but then find out that it is occupied. We have also faced the challenge of being at the back of the plane, but not having our first food preference because they ran out of it by the time they got to us. These frustrations inspired us to create In-Flight Services to make the passenger experience even better.

What it does

There are 2 features: Restroom reservations & Food orders. For restroom reservations, you can see which toilets are currently occupied and which ones are not. This will allow you to reserve a toilet before anyone can claim it. For food orders, you can claim your food choice so that there is no risk of it running out by the time the food gets to you. This will allow the flight attendant to also know which seat is getting what food and they can just hand out the food.

How we built it

We used next.js with react to build our application. We use javascript for the majority of the application and typescript for our API endpoints. We used postgresql for our database. We also used java to populate the databases.

Challenges we ran into

We ran into the challenge of getting our postgresql onto the cloud. However, we decided against it as we would need to pay for that service. We also had a bit of trouble with our API calls, but were able to fix it by changing our root directory.

Accomplishments that we're proud of

We are proud of our API endpoints and connecting the frontend with the backend properly. We are also proud of our design as we think it flows really well and is simple.

What we learned

We learned a lot about next.js and using API endpoints within it. We also learned a little bit about using pgAdmin for postgresql.

What's next for In-Flight Services

We would like to upload our postgresql onto the cloud so any user can access it. We would also like to add new features such as seat selection where passengers can put in if they want to exchange seats.

Built With

• css
• html
• java
• javascript
• next.js
• postgresql
• react
• sql
• typescript