Title: Online Application for Salon Management System with Mobile App Support
Introduction and Project Description:
The project entitled Online Application for Salon Management System with Mobile App Support is a cloud-based technology for managing hair salon. The application is designed and developed using web technologies such as PHP and MariaDB for the backend programming and Bootstrap for front-end or for the design and interface of the project. Aside from being an online application, it is also compatible for mobile devices because the design is responsive.
Online Application for Salon Management System with Mobile App is the solution to upgrade the manual method of business transaction between the management and the customers. The said project will cover appointment scheduling, billing for customers, customers records management, integrated point of sale and inventory module, mobile access, reports management and database maintenance. The detailed description of the system modules will be discussed further in the System Features section of this article.
With the implementation of this project, the researchers believe that it will be a great help for the management and employees of salon and to its clientele as well.
Advantages
- The online application runs 24/7, the customers can view the promos, discounts and special offers through its website.
- Get free updates and news through its newsletter
- Hassle free appointment scheduling
- Automated computation of billing and reports generation
- Inventory Tracking and Management
Objectives of the Study
The primary objective of this study is to design and develop an online platform for salon to manage its transactions and to improve its business processes.
Specifically, the study aims to:
- Convert the manual process of salon management into an online platform with mobile app support.
- To design a hassle free accounting and inventory management system for salon.
- To provide a user-friendly environment for the management of salon and its customers.
- To provide and generate timely and accurate reports.
- To provide a better searching facility for the management and customers.
- To organize and secure the records in proper implementation and design of the database.
Beneficiaries of the Study
The following will be the direct persons that will be aided by the Online Application for Salon Management System with Mobile App Support
Management of the salon – with the implementation of this platform, it is believe that it will enhance the business process of salon, it will also somehow a way to promote its business in digital world.
Employees of salon – employees of the salon can also be the beneficiary of this study because with the use of this system they will no longer record the transactions manually and rest assured that the records will be safe and accurate.
Customers and clients – news, promos, updates and setting of appointment is one click away. The project will also be available in mobile devices which mean that the implementation it is very convenient on the part of the customers.
System Modules ad Features
Online Appointment Booking and Scheduling – this module will allow the users or the customers to set the desired date of appointment with the salon
Customers Records Management – this module is for the personal records of customers as well the as transaction details
Billing – this module is responsible for the generation of customers billing and invoice.
POS and Inventory Management – this is the module to monitor the sales and items or supplies of the salon.
Reports Management and Generation – the system provides reports from billing, inventory, customers transaction. Generated reports are fast, accurate and reliable compare to the manual process.
Marketing and Promotion – marketing and other means to promote your products and services is very convenient and easy to manage.
Database Design/Schema
The project Online Application for Salon Management System with Mobile App Support has a total of 7 tables and the tables are the following:
tblusers (userid, username, password, completename, contact, address, usercategory)
CREATE TABLE `tblusers` (
`userid` int(11) NOT NULL,
`username` varchar(30) NOT NULL,
`password` varchar(30) NOT NULL,
`completename` varchar(50) NOT NULL,
`contact` varchar(11) NOT NULL,
`address` varchar(100) NOT NULL,
`usercategory` varchar(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Users table will store the information of users of the system such as the username, password, name, contact, address and user category. User category has two types, the administrator or manager and the employee or cashier.
tblproducts (productid, productname, description, capitalprice, retailprice, discount, quantity, expirydate)
CREATE TABLE `tblproducts` (
`productid` int(11) NOT NULL,
`productname` varchar(50) NOT NULL,
`description` varchar(100) NOT NULL,
`capitalprice` double NOT NULL,
`retailprice` double NOT NULL,
`discount` double NOT NULL,
`quantity` int(11) NOT NULL,
`expirydate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Products table will store information of the different products in salon that is for sale, the information includes then product name, description, capital price, the retail price, discount if any, the quantity in the inventory and the expiry date.
tblservices (serviceid, servicename, description, price, discount)
CREATE TABLE `tblservices` (
`serviceid` int(11) NOT NULL,
`servicename` varchar(50) NOT NULL,
`description` varchar(100) NOT NULL,
`price` double NOT NULL,
`discount` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Services table will store information on the different service offered by the salon, the information includes the name of the service, detailed description, price and the discounted price.
tblsales (salesid, customerid, productserviceid, qty, discountedprice, subtotal, daterecorded, saletype, userid)
CREATE TABLE `tblsales` (
`salesid` int(11) NOT NULL,
`customerid` int(11) NOT NULL,
`productserviceid` int(11) NOT NULL,
`qty` int(11) NOT NULL,
`discountedprice` double NOT NULL,
`subtotal` double NOT NULL,
`daterecorded` date NOT NULL,
`saletype` varchar(10) NOT NULL,
`userid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Sales table will store information on the product sold or the service that was availed by the customer. The table also includes the customer information, discounted price, subtotal, the date of transaction, transaction type which is either product sale or service.
tblblog (blogid, blottitle, content, daterecorded, timerecorded, userid)
CREATE TABLE `tblblog` (
`blogid` int(11) NOT NULL,
`blogtitle` varchar(60) NOT NULL,
`content` varchar(500) NOT NULL,
`daterecorded` date NOT NULL,
`timerecorded` time NOT NULL,
`userid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Blog table is used to store information about the news, updates and other information that will be posted on the website of the application.
tblcustomers (customerid, customername, contact, address, email, gender, username, password, accountstatus)
CREATE TABLE `tblcustomers` (
`customerid` int(11) NOT NULL,
`customername` varchar(50) NOT NULL,
`contact` varchar(11) NOT NULL,
`address` varchar(100) NOT NULL,
`email` varchar(50) NOT NULL,
`gender` int(2) NOT NULL,
`username` varchar(30) NOT NULL,
`password` varchar(30) NOT NULL,
`accountstatus` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
customers table is used to hold information of the customers such as the name, contact, address, email, gender, username, password and the account status if it is verified or not. This table is also used of the registration of new members or customers of the salon.
tblappointment (appointmentid, appoinmentdate, appointmenttime, customerid, appointmentdetails, status, remarks)
CREATE TABLE `tblappointment` (
`appointmentid` int(11) NOT NULL,
`appoinmentdate` date NOT NULL,
`appointmenttime` time NOT NULL,
`customerid` int(11) NOT NULL,
`appointmentdetails` varchar(100) NOT NULL,
`status` int(2) NOT NULL,
`remarks` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Appointment table is the table used to store the booking of customers. The information includes the appointment date, the appointment time, customer information, details of appointment, status of the booking if it is confirmed, cancelled or rescheduled, remarks refers to the explanation, comments or reason of the booking.
You may visit our facebook page for more information, inquiries and comments.
Hire our team to do the project.
