This is a retail sales management system built with Node.js and Express. It allows managing customers, menu items, orders, and more for an ice cream shop.
- Node.js
- Express
- EJS for templating
- jQuery for DOM manipulation
- Bootstrap for styling
- CSS custom styles
The backend Express server handles the API routes and database integration. The frontend uses EJS templates served by the Express server. jQuery scripts add interactivity and manipulate the DOM. Bootstrap provides styling and layout.
- Add, Edit, Delete Customers: Easily manage customer information, including adding new customers, updating existing customer details, and deleting customers as needed.
- Track Reward Points: Maintain a record of customer reward points, enabling a loyalty program that incentivizes repeat business.
- Manage Menu Items: Create, update, and delete menu items, ensuring an up-to-date and appealing selection for customers.
- Customize Flavors and Containers: Tailor the flavors and containers available to provide a personalized dining experience.
- Add, Edit, Delete Orders and Suborders: Streamline the ordering process with comprehensive controls over orders and suborders, including modifications and deletions.
- Intuitive Order Input: Utilize a user-friendly interface to effortlessly add new orders and suborders, streamlining the process and enhancing efficiency.
- Connects to a MySQL Database: Utilize a robust MySQL database to store and retrieve all system data, ensuring reliable and efficient operations.
npm install
Update the db credentials in database/db-connector.js
node app.js
The server will start on port 52990.
The MySQL database schema contains the following tables:
- Customers
- Menu Items
- Orders
- Suborders
- Flavors
- Containers
- Add authentication
- Improve input validation