Skip to content

Latest commit

 

History

History
88 lines (67 loc) · 2.93 KB

README.md

File metadata and controls

88 lines (67 loc) · 2.93 KB

Pan

Last Update Activity

Pan is an inventory management system made for Pan. This system was made with the use of MySQL, React, Express, and Node.js.

Functionalities

  • Generate reports, such as:
    • Inventory Report, which contains the beginning and ending stocks, the number of goods sold, and the gross profit of each product within a month.
    • Sales Report contains the top performing, least performing, and various statistics of the different products in the system.
    • Supplier Stock Report, which contains the 'stock in' of the different suppliers within a month.
    • Employee Details Report
    • Daily Sales Report
  • Manage company resources such as employees, products, stocks, and suppliers.
  • Track, manage, and place orders based on the available products, and stocks in the system.
  • Filter data within the system.
  • Role-based authorization on different functionalities.
  • Authentication using JWT tokens.

Setup

  1. Clone this project to your local machine.
  2. Import pan_db.sql into your local MySQL database, and run your MySQL database.
  3. Create a Redis instance locally or through Redis Labs.
  4. Create a SendGrid account.
  5. Create .env files in the client directory and server directory.

    The environment variables should contain the following:

# server/.env should contain the following variables

SENDGRID_API_KEY  = <<your sendgrid api key here>>
REDIS_HOST        = <<your redis host here>>
REDIS_USERNAME    = <<your redis user name>>
REDIS_PASSWORD    = <<your redis password>>
REDIS_PORT        = <<your redis port>>

# client/.env should contain the following variables

VITE_SERVER_URL   = http://localhost:3000/api/v1
  1. Run the following script in a terminal.
cd client
npm i
npm run dev

cd ../server
npm i
npm run dev
  1. You should be able to login through the login portal using the following credentials.

Employee

email: [email protected]
password: pan@employee123!

Manager

email: [email protected]
password: pan@manager123!
  1. ...
  2. Profit!

Contributing

Unfortunately, we are not accepting pull requests, since this is a one-time project. However, feel free to fork this project, and improve on it!

Authors and Acknowledgement

License

MIT