Download PHP and Mysql project design for salary payroll and more Study Guides, Projects, Research Information Technology in PDF only on Docsity!
Department of Computer Application
Industrial Project II (Lab)
A
Project Report on
Salary PayRoll Management System Submitted In partial fulfillment For the Award of the Degree of B. Sc. IT 3rd^ SEM. By
Shafiu Sani, SID: 62620
Under the Supervision of:
Mrs. Priya Soni
Table of Contents
DEDICATION................................................................................................................................................ i
salary payroll management system shafiu sani, 63210
Page 1 of 18
CERTIFICATION..........................................................................................................................................ii
ACKNOWLEDGEMENT............................................................................................................................iii
- SALARY PAYROLL MANAGEMENT SYSTEM IN PHP USING MYSQL:............................................ CANDIDATE’S DECLARATION............................................................................................................... iv
- INTRODUCTION:........................................................................................................................................
- OVERVIEW OF THE PROJECT..................................................................................................................
- THE AIM OF THIS PROJECT.....................................................................................................................
- ADMIN.....................................................................................................................................................
- ADD EMPLOYEES......................................................................................................................................
- DISPLAY EMPLOYEE DETAILS................................................................................................................
- UPDATE EMPLOYEE RECORDS..............................................................................................................
- DELETE.....................................................................................................................................................
- SALARY CALCULATION.........................................................................................................................
- SALARY DISPLAY....................................................................................................................................
- CONCLUSION............................................................................................................................................
- shafiu sani, salary payroll management system
CERTIFICATION
The undersigned have reported, certified and recommended to the Department of Computer Application for the acceptance of this project with title: Salary PayRoll Management System (PayRoll) carried out and submitted by Shafiu Sani SID: 63210, as meeting the requirement for the Award of degree of Bachelor of Information Technology in program of study.
salary payroll management system shafiu sani, 63210
Page 13 of 18
ACKNOWLEDGEMENT
I wish to express my profound gratitude to my humble supervisor Mr. Saif Ali , for his patience and diligence he exhibited in guiding me at every stage of this project report, particularly for making valuable corrections and useful suggestions. I also appreciate the efforts of my lecturers Mrs Priya Soni in the Department who were not only lecturing but also guiding me from beginning of my semester to date. Thanks You Mom.
salary payroll management system shafiu sani, 63210
Page 13 of 18
SALARY PAYROLL MANAGEMENT SYSTEM IN PHP USING MYSQL:
INTRODUCTION
Salary Payroll Management System is the art of managing all the finance related activities like calculating the employee’s salaries and other financial allowances who are working in a particular institution every month.
In the Salary Payroll Management System, there are activities like calculating the salary of the employee with all the allowances like travel allowance, home allowance, overtime allowances and others and deductions of the salary due to leaves in the particular month and the key factor in generating the salary pay-slips of the particular month.
As we know every month the organization should pay the salaries that is a bit difficult process because there will be thousands of people working under a particular institution/company under many branches and in the different designations.
Calculating each person salary according to the designation with all the allowances and deductions based on the work of the particular month is probably a big headache for the organization.
If we perform all these operations manually it will take a lot of time and may arise some mistakes because they will be calculating a large number of salaries. For this, the alternate method is computerizing the payroll management system.
It will be a great advantage for all the organizations because they can save a lot of time calculating the salaries and they can minimize the mistakes of calculating the wrong salaries.
In this, if we feed once the salaries for different designations and it will calculate the salaries of the employees based on the number of days they were present with all the allowances.
Let us see the flow of this project “Salary Payroll Management System” in some points:
- Admin will log in into the system with his id and password through the login page.
- Signup option will be there in this through this page the new admin can be registered by giving his details.
- After a successful login home page will be opened in this page you can see some options. The options will be like this add employee, employee details, salary calculation, all salaries.
- Add employee, in this page, the admin will add some employees
- Employee details, we can see all the employees details. In this particular page, the details will be displayed. If we recognize any mistakes we can update the employee details.
- The salary calculation, on this particular page the salaries of the employees will be calculated.
- All the employee’s salaries will be displayed in the all salaries page.
If any employees leave the company he can also delete their details and he can also display all the employee’s salaries at once. The admin will have full privilege to read, write and execute the management system. No other person has a privilege to access into the system.
I have created a database called Salary that can store records/information of the organization for easy identification when they are looking for any records including admin records or employee. Below is the picture of the database I have created containing three tables;
The picture below is a database table called calcul that calculate the employee salary.
THE AIM OF THIS PROJECT
This project is focused on maintaining data of the employees of organization and calculation of salaries, so it is named “Salary Payroll Management System”.
Here, we can add/delete a new employee records, display employee details, update information, view and manage the existing information and view employee information. Overall, with this project, you can analyze the salaries and details of employees based on the designation.
The salary payroll management system description:
all the operations will be under his control. And he is responsible for all the activities related to this management system.
This picture below shows the homepage of an accountant after provided account details to the system as a dashboard, now is ready.
ADD EMPLOYEES......................................................................................................................................
After the successful login of the admin, the admin will now add the employees who are newly joined to the organization. In this, he will fill the details of the employee like name, address, id, joined date, and designation.
Only the admin has the authority to add all the employees of the organization and no one will be able to add them. See the picture below which indicates how an admin (accountant) will add new employee details, after providing all the necessary information, then click submit button, the new employee records will be stored at employee table database.
The details of the employee in this will be his name, employee id, salary, designation. In this particular page, we can update the employee information if the entered details of the employees are wrong. We can also delete the employee details if an employee left the organization.
UPDATE EMPLOYEE RECORDS..............................................................................................................
The admin had to updated on employee records when the employee got promotion, his record has to maintained and update, like his designation has to change for example if employee on rank Assistant Data Officer after promotion become Data officer so his salary has to change.
In this picture below you will see in the right-side of the employee details an update panel where by admin can update records employee
The below show the update records of the employee data after the admin provide employee id and click update it will take the admin to this page, so that he can update the data click update button.
We can do this update using SQL command like this;
UPDATE employee SET Name = Sani, Designation= 'Manager' WHERE empid = sp011;
DELETE.....................................................................................................................................................
Delete is also part of this project because each database operate correctly and its well function must have deletion option, when an employee resign from the organization/company hi data has be delete from the salary payroll. So considering this issue we have provided the option for delete see the picture below;
When the admin search employee record by employee id and hit enter can easy delete the employee from salary payrall, can also be deleted from the database. With SQL command like this;
DELETE FROM employee WHERE empid = ‘sp001’;
In the above picture shows that the employee salary will be calculated by giving his employee ID. Since the salaries for all the designations are predefined we will give the number of leaves taken by the employee in the current month according to this the salary will be calculated.
If the employee had taken only one leave then no salary will be deducted in that month. The salary can be calculated for all the months and you can display the details of the salary.
SALARY DISPLAY....................................................................................................................................
In this section, we will display the salaries of the employees of the particular month. We will display the salary of a particular employee ID. In this page, the details will be like this employee ID, his basic salary, the number of leaves taken. The salary deducted based on the number of leaves taken in the particular month. These details will be displayed on this particular page.
In the picture above the details salary of the employee display in the window.
