SIMS (Stock Inventory Management System)

A full-stack exam-style project for spare parts, stock in/out, users, and reports.

Backend

1. Open backend.
2. Copy .env.example to .env.
3. Install dependencies:
   • npm install
4. Create the database:
   • Run the SQL in backend/db.sql on MySQL.
5. Start the backend:
   • npm run dev or npm start

Frontend

1. Open frontend.
2. Install dependencies:
   • npm install
3. Start the dev server:
   • npm run dev

Notes

• Backend uses Express, MySQL, bcryptjs, express-session.
• Frontend uses React, Axios, Tailwind CSS, Vite.
• The login endpoint uses session authentication.
• Reports include daily stock out and stock status with SQL JOINs and GROUP BY.