Inventory Management System

InvSys is the web application for inventory management system Department Inventory where students borrow components for their projects.

Preview

Quick Start

• Clone the repo: $ git clone https://github.com/knztnt/InvSys.git

  or

• Download from Github

Running Locally

Navigate to root directory of the project.

   $ npm install
   $ cd client
   $ npm install
   $ cd ..
   $ npm run dev

Database Connection Configuration

Run following script. InvSys.sql

CREATE DATABASE invsys;

In InvSys/app/config/db.config.js (Line 3 and 4), set your MySQL database username and password as follows. Default values are, username: 'root' and password: ''.

module.exports = {
  HOST: "localhost",
  USER: "root",
  PASSWORD: "",
  DB: "invsys",
  dialect: "mysql",
  pool: {
    max: 5,
    min: 0,
    acquire: 30000,
    idle: 10000,
  },
};

! For the First Time running the Server

In InvSys/app/server.js file, uncomment (29-32) lines and comment 26th line. This will initialize the database and sync all the tables. Or simply replace exixting server.js file with following script. Following script contains the server.js file when it is run initially.

InvSys server file | Resets database to initial state

Powered by

• nodejs
• React
• MySQL

Dependencies

Server side

• bcryptjs
• body-parser
• cors
• express
• jsonwebtoken
• mysql2
• sequelize

Client side

• axios
• bootstrap
• fontawesome
• jwt-decode
• prop-types
• react
• react-avatar
• react-datepicker
• react-dom
• react-router-dom
• react-scripts
• react-validation
• validator

Developer dependencies

• nodemon
• concurrently

Documentation

• Database Project Report
• Software Engineering Project Report

Deployment

Author

• knztnt Solutions - http://knztnt.github.io

Contributors

• Chamin Jayasooriya
• Anandi Karunaratne
• Devin Gallage