Attendance and Payroll System using PHP

Submitted by: 
Language: 
Visitors have accessed this post 5467 times.

Features:

  • CRUD - Employee Attendance
  • CRUD - Employee
  • Employee Cash Advance
  • Employee Overtime
  • Employee Schedule
  • Payroll on Date Range
  • Payslip on Date Range

Plugins:

  • AdminLTE
  • TCPDF library

Installation

1. Download the source code using the Download button below.

2. Extract the downloaded file to your localhost folder ex. htdocs for XAMMP.

3. Import the included .sql file which is the database of the system. If you have no idea on how to import, please refer to my tutorial on How import .sql file to restore MySQL database.

4. After a successful import, open the extracted folder and open conn.php in both the root folder and in admin/includes folder. Edit the database name in the connection depending on the name of database you created in importing the included .sql file.

Accessing the Admin

You can access the admin side by adding /admin/. You should be able to navigate to admin login page.

You can then use the below admin credential:

Username: nurhodelta
Password: password

That's it. You should now be able to run the simple system :)

If you have any suggestions, comments or reactions, feel free to comment below or message me.

Happy Coding :)

*Updates: 05-21-18
1. Fixed dynamic buttons (edit, delete, etc ) not functioning on page2 or more of table.
2. Fixed time in showing late even on time.


Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Field 'status' doesn't have a default value

Hi. I downloaded and wanted to explore this system but i cant login as admin..i used username and pswd in the database and even tried changing several times but it keeps saying incorrect pswd on the admin login page. Pls help

The password is hashed..you should not have changes the password directly in your phpmyadmin...reset the database again and use the credential provided..there shouldnt be a problem...

please help how to debug this problem sir

Hi there. After adding employees or positions and even the attendance..after going to the next page..the edit and delete buttons dont work from the second page. Kindly advise

Just change the button for edit and delete..

For edit:
$(document).on('click', '.edit', function(e){
e.preventDefault();
///the codes here
});

For delete
$(document).on('click', '.delete', function(e){
e.preventDefault();
///the codes here
});

Same goes for other dynamic buttons

Hey. Thanks so much, your earlier feedback worked perfectly for the edit and delete buttons. What should i do about the employee sign in..its now not working or submiting emp id. Ua help will be appreciated.

Hi. When i make changes say with the edit and delete buttons from page 2 onwards, the page always reloads to the first page. How can i make it to remain on the current page after changes. Thank u

Hi. The system doesnt record overtime unless i add it manually. Can it reflect automatically? Pls advise

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.