Skip to content

Mini project for an online reservation system for retail within a school / university

Notifications You must be signed in to change notification settings

jcilacad/reservation-system

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Reservation System

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes.

Prerequisites

  • Git
  • MariaDB Server
  • Maven
  • Java

Installation

  1. Clone the project

    Use the following command to clone the project:

git clone [email protected]:jcilacad/reservation-system.git
  1. Create a database

Open your MariaDB server and create a new database named reservation_system:

CREATE DATABASE reservation_system;
  1. Update application.properties Navigate to the application.properties file in the project directory and update the username and password fields with your MariaDB server credentials:
spring.datasource.username=root
spring.datasource.password=password
  1. Update AdminSeeder class Navigate to the AdminSeeder class located at src/main/java/com/system/reservation/online/bootstrap/ and update the admin credentials as needed. (The name must have a middle name, follow the format in the code)

  2. Start the application Use Maven to start the application:

mvn spring-boot:run

Demo

Admin Side

  1. Once you have logged in using the admin credentials, go to /admin to view the admin's dashboard.
  2. In the accounts tab, you can add, query, update, and delete students.
  3. In the items tab, you can add, query, update, and delete items.
  4. In the transactions tab, you can query, view, approve, cancel, and delete transactions.
    • Remarks:
      • Pending: The student has placed the reserve item(s).
      • Approved: The admin has approved the reserved item(s).
      • Completed: The item has already been given to the student by the admin.
      • Cancelled: The item has been cancelled by the admin/student.
      • Overdue: The item is overdue based on the date inputted by the student.
  5. You can generate bulk reports by remarks or generate reports individually by student email.

Student Side

Note: The default password for the student is their student number. You can change the password in the 'Change Password' module in the app.

  1. Once logged in, the student will be redirected to the dashboard.
  2. In the items tab, you can query, view, and reserve items.
  3. You can view, query, generate, and cancel reserved items.

Screenshots

Login Module

image

Change Password Module

image

Admin

Dashboard

image

Accounts Tab

image

Accounts Tab (Add Student)

image

Accounts Tab (View)

image

Accounts Tab (Update)

image

Items Tab

image

Items Tab (Add)

image

Items Tab (Update)

image

Transactions Tab

image

Transactions Tab (View)

image

Report Tab

image

Student

Dashboard

image

Items Tab

image

Items Tab (View)

image

Transactions Tab

image

Transactions Tab (View)

image

Transactions Tab (Report Generation based on status)

image