💇‍♀️ Raddison Salon - Beauty & Wellness Management System

Welcome to Raddison Salon, a modern and elegant web-based salon management system built to streamline appointment bookings, service management, and customer interactions. This project brings together beauty and technology to create a seamless experience for both salon staff and customers.

✨ Features

🎨 For Customers

Browse Services: Explore our collection of regular and premium beauty services with detailed descriptions
Easy Booking: Book appointments with your preferred staff member and time slot
Service Categories:
- Regular Services (Haircuts, Styling, Grooming, Facials, etc)
- Premium Services (Luxury Spa, Gold Facial, Diamond Glow treatments, etc)
Contact Us: Send inquiries and feedback directly through the website
Responsive Design: Beautiful, mobile-friendly interface that works on all devices
Real-time Availability: See available time slots and service durations

👨‍💼 For Administrators

Dashboard Overview: Get insights into appointments, customers, and services at a glance
Appointment Management:
- View, create, edit, and cancel appointments
- Update appointment status (Scheduled, Completed, Cancelled)
- Add notes for special customer requests
- Expandable notes feature for detailed information
Staff Management: Add, edit, and remove staff members with role assignments
Customer Database: Maintain customer records with contact information
Service Management:
- Separate tabs for Regular and Premium services
- Create, update, and delete services
- Set pricing and duration for each service
Message Center: View and manage customer inquiries from the contact form
Secure Login: Password-protected admin panel with bcrypt encryption

🔐 Security Features

Hashed password storage using bcrypt
Database reconnection with exponential backoff
Foreign key constraints for data integrity
SQL injection prevention with parameterized queries
Secure admin authentication

📸 Screenshots

Homepage

Welcome page featuring our elegant pastel-themed design with salon introduction and call-to-action

Services

Browse through our comprehensive collection of regular beauty services with detailed descriptions and pricing

Premium luxury services section showcasing our exclusive spa and treatment packages fetched live from database

Book Appointment

Easy-to-use appointment booking form with customer details, service selection, and preferred time slots

About Us

Learn about Raddison Salon's story, mission, and commitment to beauty excellence

Meet our professional team (data is fetched directly from database not hard-coded)

Contact Us

Get in touch with us through our contact form or find our location and business hours. Send a message which can be displayed through admin dashboard

Admin Dashboard

Comprehensive admin panel overview showing appointments, customers, and service management

Appointment management interface with status tracking, notes, and expandable details

Staff management section for adding, editing, and organizing salon employees

Customer database with contact information and relationship tracking

Service management with separate tabs for regular and premium services, including pricing and duration settings

🛠️ Tech Stack

Frontend:

HTML5, CSS3 (Custom pastel-themed design)
Vanilla JavaScript (ES6+)
Font Awesome Icons
Google Fonts (Poppins & Playfair Display)

Backend:

Node.js (v18+)
Express.js (v4.18.2)
MySQL2 (v3.6.0)

Security & Utilities:

bcrypt (v6.0.0) - Password hashing
dotenv (v16.3.1) - Environment variables
cors (v2.8.5) - Cross-origin resource sharing
body-parser (v1.20.2) - Request parsing

📋 Prerequisites

Before you begin, make sure you have the following installed:

Node.js (version 18 or higher) - Download here
MySQL (version 8.0 or higher) - Download here
Git (optional, for cloning) - Download here
A text editor like VS Code - Download here

🚀 Installation & Setup

Step 1: Clone or Download the Project

Option A: Clone with Git

git clone https://github.com/DBMS-4/raddison-salon.git
cd raddison-salon

Option B: Download ZIP (No Git Required)

Go to https://github.com/DBMS-4/raddison-salon
Click the green "Code" button → "Download ZIP"
Extract the ZIP file to your desired location
Open terminal/command prompt in the extracted folder

Step 2: Install Dependencies

Open your terminal in the project directory and run:

npm install

This will install all the required packages listed in package.json.

Step 3: Set Up MySQL Database

Start MySQL Server
- Make sure your MySQL service is running
- Open MySQL Workbench or command line
Create the Database
```
CREATE DATABASE raddison_salon;
```
Import the Database Schema

Run the database.sql file to create all tables and insert sample data:

Using MySQL Command Line:
```
mysql -u your_username -p raddison_salon < database.sql
```
Using MySQL Workbench:
- Open MySQL Workbench
- File → Run SQL Script
- Select database.sql
- Click "Run"

Step 4: Configure Environment Variables

Easy Method: Rename .env.example to .env

Then edit the .env file with your MySQL credentials:

# Database Configuration
DB_HOST=localhost
DB_USER=root
DB_PASSWORD=your_mysql_password
DB_NAME=raddison_salon
DB_PORT=3306

# Server Configuration
PORT=3000

⚠️ Important: Replace your_mysql_password with your actual MySQL password!

Step 5: Start the Server

Run the application:

# For development (with auto-restart on changes)
npm run dev

# For production
npm start

You should see:

Server is running on port 3001
Connected to MySQL database successfully!

Step 6: Access the Application

Open your web browser and visit:

Homepage: http://localhost:3000
Services Page: http://localhost:3000/services.html
Book Appointment: http://localhost:3000/appointment.html
About Us: http://localhost:3000/about.html
Contact: http://localhost:3000/contact.html
Admin Panel: http://localhost:3000/admin.html

🔑 Default Admin Credentials

Use these credentials to access the admin panel:

Username: admin
Password: ADMIN1234

⚠️ Important: Please change the default password after your first login for security purposes!

📁 Project Structure

raddison-salon/
│
├── public/                          # Frontend files
│   ├── index.html                   # Homepage
│   ├── services.html                # Services listing
│   ├── appointment.html             # Booking form
│   ├── about.html                   # About page
│   ├── contact.html                 # Contact form
│   └── admin.html                   # Admin dashboard
│
├── server.js                        # Express server & API routes
├── database.sql                     # Database schema & sample data
├── package.json                     # Node.js dependencies
├── .env.example                     # Environment variables template
├── .env                            # Your actual credentials
├── .gitignore                      # Files to ignore in Git
├── LICENSE                         # Custom license file
└── README.md                       # This file!

🔌 API Endpoints

Services

GET /api/services - Get all regular services
GET /api/premium - Get all premium services
GET /api/all-services - Get all services
POST /api/services - Create a new service
PUT /api/services/:id - Update a service
DELETE /api/services/:id - Delete a service

Appointments

GET /api/appointments - Get all appointments
POST /api/appointments - Create an appointment
PUT /api/appointments/:id - Update appointment
PUT /api/appointments/:id/status - Update appointment status
DELETE /api/appointments/:id - Delete appointment

Staff

GET /api/staff - Get all staff members
POST /api/staff - Add new staff
PUT /api/staff/:id - Update staff info
DELETE /api/staff/:id - Remove staff

Customers

GET /api/customers - Get all customers
POST /api/customers - Add new customer
PUT /api/customers/:id - Update customer
DELETE /api/customers/:id - Delete customer

Messages

GET /api/messages - Get all messages
POST /api/messages - Submit contact form
DELETE /api/messages/:id - Delete message

Admin

POST /api/admin/login - Admin authentication

🎨 Design Features

Pastel Color Scheme: Soft pink and lavender tones for a welcoming feel
Mobile Responsive: Works beautifully on phones, tablets, and desktops
Smooth Animations: Hover effects and transitions for a polished experience
Accessible Navigation: Mobile hamburger menu with smooth transitions
Service Cards: Flexbox-aligned cards with consistent button positioning
Admin Dashboard: Clean, organized interface for easy management

🐛 Troubleshooting

Server won't start

Make sure MySQL is running
Check if port 3000 is already in use
Verify your .env file has correct database credentials

Database connection failed

Confirm MySQL service is running
Double-check username and password in .env
Ensure the database raddison_salon exists
Check if the port (default 3306) is correct

"Cannot find module" error

Run npm install to install all dependencies
Delete node_modules folder and run npm install again

Admin login not working

Make sure the Admins table has the default user
Verify bcrypt is installed: npm install bcrypt

🤝 Contributing

While this is a personal project, suggestions and feedback are always welcome! Feel free to:

Report bugs by creating an issue
Suggest new features
Share your experience using the system

📝 Database Schema

The system uses 6 main tables:

Staff - Store employee information
Customers - Customer database with contact details
Services - Both regular and premium services
Appointments - Booking records with status tracking
Messages - Contact form submissions
Admins - Admin user accounts

For detailed schema, see database.sql.

📧 Support & Contact

If you encounter any issues or have questions:

Check the Troubleshooting section above
Review the API documentation
Ensure all prerequisites are installed correctly

🎓 Educational Purpose

This project was created as a Database Management System (DBMS) course project to demonstrate:

Database design and normalization
CRUD operations implementation
Frontend-backend integration
RESTful API development
User authentication and security
Real-world application development

🙏 Acknowledgments

Font Awesome for beautiful icons
Google Fonts for typography
The Node.js and Express.js communities
MySQL documentation and resources

📜 License

This project is licensed under a Custom License - see the LICENSE file for details.

Note: Commercial use and redistribution are not permitted without explicit permission.

🌟 Features Roadmap (Future Enhancements)

SMS/Email notifications for appointments
Payment gateway integration
Customer loyalty program
Staff scheduling system
Revenue analytics dashboard
Multiple salon locations support
Online payment processing
Customer reviews and ratings

Made with ❤️ for Raddison Salon

⭐ If you found this project helpful, please consider giving it a star!

Name		Name	Last commit message	Last commit date
Latest commit History 6 Commits
public		public
screenshots		screenshots
.env.example		.env.example
.gitignore		.gitignore
LICENSE		LICENSE
README.md		README.md
database.sql		database.sql
package.json		package.json
server.js		server.js

Folders and files

Latest commit

History

Repository files navigation

💇‍♀️ Raddison Salon - Beauty & Wellness Management System

✨ Features

🎨 For Customers

👨‍💼 For Administrators

🔐 Security Features

📸 Screenshots

Homepage

Services

Book Appointment

About Us

Contact Us

Admin Dashboard

🛠️ Tech Stack

📋 Prerequisites

🚀 Installation & Setup

Step 1: Clone or Download the Project

Step 2: Install Dependencies

Step 3: Set Up MySQL Database

Step 4: Configure Environment Variables

Step 5: Start the Server

Step 6: Access the Application

🔑 Default Admin Credentials

📁 Project Structure

🔌 API Endpoints

Services

Appointments

Staff

Customers

Messages

Admin

🎨 Design Features

🐛 Troubleshooting

Server won't start

Database connection failed

"Cannot find module" error

Admin login not working

🤝 Contributing

📝 Database Schema

📧 Support & Contact

🎓 Educational Purpose

🙏 Acknowledgments

📜 License

🌟 Features Roadmap (Future Enhancements)

About

Resources

License

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Uh oh!

Contributors

Uh oh!

Languages

Packages