A backend server for a Smart Point-of-Sale (POS) system, built with Node.js, Express, and PostgreSQL. This server provides RESTful APIs for managing products, inventory, sales, employees, branches, customers, suppliers, and more.

• Features
• Tech Stack
• Project Structure
• Database Schema
• Setup & Installation
• Environment Variables
• API Endpoints
• File Uploads
• Authentication
• Scripts
• License

• User authentication (JWT)
• Role-based access control
• Product, category, inventory, and supplier management
• Employee and branch management
• Customer and sales history tracking
• Cart and order processing
• File/image upload support
• RESTful API design

• Node.js (v18+)
• Express.js
• PostgreSQL
• JWT for authentication
• Multer for file uploads
• dotenv for environment configuration
• CORS support

smart_pos_server/
│
├── config/ # Database and app configuration
│ ├── config.js
│ └── database/
│ ├── schema.sql
│ ├── a_createTables.sql
│ └── ... (other SQL scripts)
│
├── controllers/ # Route controllers
├── middleware/ # Custom middleware (auth, upload)
├── models/ # Database models
├── public/ # Static files and images
├── routes/ # API route definitions
├── utils/ # Utility functions
├── server.js # Main server entry point
├── package.json
└── README.md

• See config/database/schema.sql and a_createTables.sql for full schema.
• Includes tables for products, categories, inventory, sales, employees, branches, customers, suppliers, user roles, and more.
• Uses foreign key constraints for data integrity.

1. Clone the repository:

   git clone https://github.com/ChandiH/smart_pos_server.git
   cd smart_pos_server

2. Install dependencies:

   npm install

3. Configure environment variables:

   • Create a .env file in the root directory with the following variables:

     PORT=4000
     DATABASE_USER=your_db_user
     DATABASE_PASSWORD=your_db_password
     DATABASE_HOST=localhost
     DATABASE_PORT=5432
     DATABASE_NAME=smart_pos_db
     SECRET_KEY=your_jwt_secret
     

   • Adjust values as needed for your environment.

4. Set up the PostgreSQL database:

   • Run the SQL scripts in config/database/ to create the database and tables.
   • Example:

     psql -U your_db_user -f config/database/schema.sql
     psql -U your_db_user -d smart_pos_db -f config/database/a_createTables.sql

5. Start the server:

   npm start

   • The server will run on the port specified in .env (default: 4000).

All endpoints are prefixed by their resource, e.g. /auth, /product, /customer, etc.

• POST /auth/login — Login and receive JWT token
• POST /auth/register — Register a new employee
• POST /auth/reset-password — Reset password

• GET /product — List products
• POST /product — Add product (supports image upload)
• GET /inventory — List inventory
• ...and more

• GET /customer — List customers
• POST /customer — Add customer
• GET /chart — Sales analytics

• GET /employee — List employees
• POST /employee — Add employee (supports image upload)
• GET /branch — List branches

• GET /cart — View cart
• POST /cart — Add to cart
• GET /supplier — List suppliers

• GET /user-role — List user roles

• Single file: POST /upload (form field: file)
• Multiple files: POST /upload-multiple (form field: files)
• Product images: POST /product (form field: files)
• Employee images: POST /employee (form field: file)
• Uploaded files are stored in public/image/

• JWT-based authentication.
• Protect routes using the authJWT middleware.
• Example usage:

  app.use("/customer", jwt.verifyToken, customerRouter);

ISC © Somesh Chandimal

For more details, see the source code and SQL schema files.

If you have any questions or need help, please contact the author or open an issue.