laplacexd/pan

Pan - An Inventory Management System made with MERN Stack

pan's Issues

Reports Module

• Look into the implementation of reports, most of these are just GET requests in an endpoint such as /api/v1/reports/:name
• Make use of VIEWS in SQL to generate the data for the reports beforehand, probably store the views in a separate file like pan_db_vw.sql
• Look into this package on converting javascript objects to XSLX

Order Issues

• Must validate if stock is enough for Product Purchase
• Must validate the array passed as a body for the request, it shouldn't allow an empty array
• Must validate whether the passed value for the product_id of details is valid
• Create Views for the SQL queries

Product Issues

• Should return the amount available in stock when product is GET, as well as the category name of the product
• Should also return category name of the product

Employee Update Validation

Employees when editing their details should not get an email already exists error if the email belongs to their account

Category ID validation when creating Products

When adding products make sure to validate for the valid category ids

Employee Issue

• date_employed should not be editable if the editor is an employee

Stock Issues

• Stock should validate product_id, and supplier_id if they exist in the database

Product and Stock Validation

• Employees should only be able to edit stock, and products they created

**NOTE: ** Ignore this for now, since this takes quite some time to implement.