Skip to content

OrbitalbooKING/booKING

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

454 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Build Status

booKING

Orbital 2021

Motivation

With the limited venues and resources available in School of Computing, students struggle to find a proper venue to study or to work on group projects. Even if a vacant venue is found, students are also uncertain whether the room is currently occupied, or whether it will be occupied halfway during their usage. In addition, if they want to use it for project meetings or discussions, they are also unsure if the venue itself has the relevant infrastructure (such as projectors, computers or seats) to suit their requirements and preferences.


Aim

To maximise the venue and resources usage in School of Computing, we hope to help users find and reserve a venue for their own usage through a simple and user-friendly web application.


Description

To maximise the venue and resources usage in School of Computing, we hope to help users find and reserve a venue for their own usage through a simple and user-friendly web application.


Documentations


Timeline

Setup: (3 weeks)

    • Setup database
    • CRUD for database
    • Basic interface
    • Design for web application

Core Features: (4 weeks)

    • User authentication
    • Adding all the venues to the database
    • Venue reservation
      • Venue classifications
      • Resources available in each venue
    • Available venues search function
    • Venue reservation notification
    • Autocomplete function in venue search bar
    • Points system
    • Create an interface for staff in SoC to view and approve/reject venue bookings, this allows them to prioritise SoC users who wants to reserve a venue

Advanced Features: (4 weeks)

    • Venue sharing system
    • Priority queue for SoC users to reserve rooms over non-SoC users

Nice-to-have Features: (2 weeks)

    • Prevent interval bookings (don’t let users book 15 mins and leave it empty for 15 mins etc)
    • Minimum number of characters for password
    • Responsive design for different screen sizes

Tech Stack

  1. ReactJS
  2. CSS/HTML
  3. PostgreSQL
  4. GOLang

Project Log

S/N Description Hours spent by Jason Hours spent by Jie Wei Time Period Remarks
1 Poster creation for Lift-off 2 2 10/5/2021 Liftoff
2 Video creation for Lift-off 3 3 10/5/2021 Liftoff
3 Team meeting: initial planning 5 5 11/5/2021 1) Layout the full idea for the project and the technology required
2) Delegated roles
3) Asked friends for feedback
4 Project research 4 4 12/5/2021 1) Read up and research on similar products in the market
2) Comparing which software is the best among similar ones
5 Mission control 3 3 13/5/2021 Met up with mentor Robin to discuss our project ideas and to get feedback on the softwares we intend to use
6 Programming at home: Frontend & Backend 2 2 16/5/2021 1) Setup PostgreSQL and make connection with Golang
2) Design simple web page using React
7 Programming at home: Frontend & Backend 3 3 18/5/2021 1) Develop APIs
2) Design buttons for login features
8 Programming at home: Frontend & Backend 3 3 22/5/2021 1) Testing of database query calls with APIs
2) Designing of registration and reset pages
9 Programming at home: Integration 3 3 26/5/2021 Successfully connected React frontend with PostgreSQL backend using Golang to carry out authentication
10 Programming at home: Integration 2 2 26/5/2021 Successfully connected React frontend with PostgreSQL backend using Go to carry out authentication
11 Documentation at home: User Guide 8 8 27/5/2021 Worked on documenting a user guide for Milestone 1
12 Documentation at home: Developer Guide 8 8 28/5/2021 Worked on documenting a developer guide for Milestone 1
13 Team meeting: Milestone review 2 2 1/6/2021 Met with mentor Loh Zi Bin Robin to look through milestone one feedbacks as well as plan out next course of action
14 Programming at home: Frontend & Backend 10 10 7/6/2021 1) Obtain venue information from NUS website to populate venue lists to store in database
2) Create API routes to fetch all venues
3) Implement search bar and venue display on react
15 Programming at home: Frontend & Backend 10 10 14/6/2021 1) Implement filters for queries to only display certain venues
2) Create booking page with a calendar for users to select their desired time slots
16 Programming at home: Frontend & Backend 10 10 21/6/2021 1) Create booking services
2) Integration of frontend and backend to test out search features and booking
17 Documentation at home: Frontend & Backend tests 8 8 25/6/2021 1) Create test files to conduct testing of backend code
2) Qualitative evaluation of application (heuristics evaluation and cognitive walkthrough)
18 Team meeting: Milestone review 2 2 1/7/2021 Met with mentor Loh Zi Bin Robin to look through milestone two feedbacks as well as plan out next course of action
19 Programming at home: Frontend & Backend 10 10 3/7/2021 1) Implement points system as well as integrate points system into bookings
2) Edit booking page to handle sharing of venue logic
20 Programming at home: Frontend & Backend 10 10 5/7/2021 1) Create edit booking and edit profile services
2) Create page for editing profile and booking
21 Programming at home: Frontend & Backend 10 10 7/7/2021 Fix and debug logic errors caused by points system and venue sharing
22 Programming at home: Frontend & Backend 10 10 12/7/2021 1) Create approve and reject booking services
2) Create interface for staff user to view, approve, reject bookings
23 Programming at home: Frontend & Backend 10 10 19/7/2021 1) Create email notification services for different features, and also service to refill user points every week
2) Improved on UI design for all the pages (eg. adding animations to indicate loading)
24 Team meeting: Project review 2 2 21/7/2021 Met with mentor Loh Zi Bin Robin to look through what we have done for the entire project so far
25 Documentation at home: Frontend & Backend tests 8 8 25/7/2021 1) Additional test files for newly updated features
2) Conducting usability testing and recording walkthrough of application
26 Documentation at home: User & Developer Guide 6 6 25/7/2021 Additions and cleaning up of user and developer guide
Total hours Jason Jiewei
152 152

Qualifications

Both of us have experience with programming using Java and Python (explored python in our free time and are currently learning Java from CS2030S this semester) hence we are confident that we will be able to utilise GOLang which is similar to both languages.

We also have basic knowledge in CSS and HTML to code and design websites (Jason has experimented with it during the MOOC course CS50 by edX while Jie Wei has designed a webpage for one of his course projects back in Temasek Polytechnic). In the same way, we have also integrated MySQL together with the websites we have designed.

About

To maximise the venue and resources usage in School of Computing, we hope to help users find and reserve a venue for their own usage through a simple and user-friendly web application.

Resources

Stars

2 stars

Watchers

0 watching

Forks

Packages

 
 
 

Contributors