InvSys

Inventory Management System | Server | Client

View the Project on GitHub knztnt/InvSys

Inventory Management System

InvSys is the web application for inventory management system Department Inventory where students borrow components for their projects. In this project, we have created an Inventory System Management System for the Department of Computer Engineering of the Faculty of Engineering of the University of Peradeniya. The objective was to digitize the current manual data storage procedure of the inventory system. The designed system runs as a user-friendly website which is connected to a database via a web server, implemented using MySQL, nodejs, React.

Image

Preview

Preview of InvSys

Quick Start

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.

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.

Powered by

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

Deployment

Author

Contributors