Human Resource Management System PHP & MySQL Web Application Project

The HR Management System is a simple academic web-based mini-project created with PHP & MySQL databases. The primary goal of this Human Resource Management System PHP project is to build a web application that helps the organization manages its human resources.

There will be the main module named the project module in the human resource management system application. It Records of all employees in the organization are stored in the application MySQL backend along with their skills and abilities. When a new company-based project is assigned to an employee team, the project module creates a new file. Details of project team members and the estimated completion date of the project or deadline will be set.

The project manager in the application should update the assessment of team members in the application. This rating is used by the application to make recommendations for promotions. The final decision on employee future promotions is made by the senior manager.

The second module of the application is the hiring module that can be used in the new employee hiring process in the company. This module provides information on future projects and progress in current projects, based on which it predicts the demand for talent.

The third and final module of the application is the Employees module, it will be available to all the employees to view their salaries and permitted leave details. Using this HRMS web application, all employees can easily check the information and ask questions at any time on the Human Resource Management System page. Top management can also use this system to access employee records and performance statistics of the employees to improve the organization’s standards.

HRMS Project

Download Human Resource Management System PHP & MySQL Web application mini project. This project was developed with HTML, CSS, Javascript and Bootstrap.

College Sports Resource Booking Android and Web Application

The main aim of this College Sports Resource Booking Android cum Web Application project is for students in the college to book sports material on the college premises. This Project is a combination of both an Android app and a Web application, where the android app is developed by Java and XML, and the web application is developed using Html, CSS, Bootstrap, Javascript, Django, and SQLite technologies.

Contents:

Introduction:

The College Sports Resource Booking Application has been developed in order to enable the ​students to book sports resources. The administrator can keep a tab on the availability of the resources along with streamlining the fine process. This application overcomes the problems prevailing in the existing manual system. It also makes it extremely simple for the students to book a resource or to check the availability of the resources, view dues if any, as well as history of bookings, and for the administrator to issue resources, impose fines and view the history of bookings.

The API developed for this application is deployed on Heroku and is ready to respond to the requests made by the application with expected outputs by accessing the database.

Scope of the project

This College Sports Resource Booking application can be used to reduce the problems faced by the manual system. The administrator can issue and reject a booking in one click and it even helps the admin to keep a tab on the Booking History and also the Blocked list of users. The administrator can also add or delete the resources. It makes it easy for the administrator to keep track of all the resources and bookings. The mobile application makes it so simple for users to book a resource and check the history of their previous bookings.

System Analysis

Introduction

Sports Resources Management System is a web and android app. The admin can add and delete resources on the web and manage the users in accepting and rejecting resources. The users can book the resources from the android app and collect them from the office within 20 min and even cancel the request.

Existing System

In the existing system, the users have to visit the sports office manually and collect the resources. And also the users cannot reserve a resource from wherever he/she is. Even though the user is blocked, he can go to the office and make a request for the resource. The admin has to manually check the user if he/she is in the blocked list and issue the resource.

Proposed System

In the proposed system, the users can reserve and book the resource from wherever they are and collect it within 20min. In this system, if a user is blocked he cannot book the new resource until he clears the fine. The user can check the fine amount to be paid by him in the android app.

Software Requirement Specification

User Requirement

There is an admin and the user i.e., a student. The minimum requirement of the user is that he/she must understand basic English and must know how to book a resource, check the fine and collect from the sports office. The admin must know how to accept the user’s request, block the user, issue resources manually and collect fines from users and unblock users.

Module Description

There are two modules in this College Sports Resource Booking project. They are users and admins.

Features of User

The user is a student who is going to use the Android Application “SportEasy”. The app has the following features:

  • Can view all the resources available in the sports block with its count in the app. This reduces the inquiry time at the issue counter.
  • He can send a booking request with just one click so that he can collect it in 20mins from his booking time.
  • The user also has the option to cancel the booking request within 20 minutes of the booking time.
  • User can view all their past booking requests with their status so that they can know what requests he made.
  • The user has the option to set his password to a new one when he forgets his password or wants to change it.

Features of Administrator

The administrator is the one who accepts and approves booking requests. They handle the Web application. The functionalities of the admin module include:

  • Adding and deleting the resource when required.
  • Accepting or rejecting the resource requested by the user based on the timetable.
  • Updating the booking depending on whether the resources were returned or not and imposing fines accordingly.
  • Blocking the user if the resource is damaged.
  • Collecting fine manually and unblocking the user.

Software Requirement

  • ​Any Web Browser
  • ​Python 3 with Django Module
  • 64-bit operating system.
  • Emulator
  • Android Studio
  • pip
  • virtualenv
  • Virtualenvwrapper
  • Flask module

Web Requirements

  • Html, CSS
  • Bootstrap
  • Javascript
  • Django

Android Requirements

  • Java
  • XML

RESTFul API Used

  • Flask

This is the Django code for displaying all the resources present in the web app

Conclusion

This College Sports Resource Booking project is for computerizing the workers employed in order to borrow a sports resource. It is a great improvement over the manual system. The computerization of the system has sped up the process. In the current system, the front office management is very slow. This application was thoroughly checked with dummy data and thus is found to be very reliable. The software takes care of all the requirements and is capable of providing easy and effective storage of information related to students who book sports resources. Responsive web design and mobile apps make work easier and safe for any field. With the provision of an easily accessible user interface, the entire process of booking and approval of resources, along with other features, has become extremely facile while also significantly averting the numerous errors that would otherwise be caused in a manual system. With this platform we developed, we are hoping to achieve the following:

● ​Reduced time wastage
● Providing comfortable facilities to students
● ​Provide easy data flow
● ​Less employee investment

Limitations

The College Sports Resource Booking mobile application which has been developed for the students for booking sports resources is only compatible with android versions 5.0+, it requires a minimum android runtime version of 5.0
The Admin has to check the timetable while issuing a resource.
There is no deadline for the user to clear the due and no notification system to intimate the user to clear the due.

Future Scope

This application can be enhanced by including numerous new features. One such feature is adding a notification system through which the admin can send notifications to a user regarding his bookings. In the current system, the user should manually go into the app and check whether the resource is accepted or not. Instead, an improvement to this would be sending a confirmation to the user when his booking request is approved by the admin. In case of unavailability of a resource, a “notify when available” button could be included too.

As of now, when a student wants to book a resource, the admin manually checks whether the student has a free hour at that particular time and issues the resource accordingly. But in the future, an app can be made which itself detects whether the student is having a free hour or not, thereby eliminating the involvement of the admin.

Subsequently, a separate page linked to the admin webpage could also be developed, where the admin can add updates about upcoming sports events or competitions in such a way that these updates will also be visible in the mobile app for students, therefore allowing them to be aware of all the ongoing or upcoming sports events through their mobile.

Download the complete College Sports Resource Booking Android App and Web Application Source code, Project Report, PPT, and How to run Video file.

Download the Complete College Sports Management System .Net Project Source Code.

Online Seminar Hall and Auditorium Booking System

The Online Seminar Hall and Auditorium Booking System is divided into four main modules. Each and every module performs a particular work. Those 4 modules are

  1. Maintenance of user and seminar hall
  2. Booking the seminar hall
  3. Approval and Rejection by In-charge
  4. Role of Principal

Maintenance of user and seminar hall

It consists of Signup, Login and update details of the seminar halls, users. The Administrator creates a separate account for each Department, Seminar hall in-charges, other cells like placement and training, EMDC etc., and Principal.

Booking the seminar hall

Each department has the username and password to book the seminar hall for their requirement. Through this they can view the available dates of particular seminar hall and also the facilities in the hall like capacity, mic’s, projector, marker board etc., This provides user-friendly environment while booking the seminar hall it gives suggestion regarding the selection of seminar hall based on the capacity and availability. The concern department head can view the list of the request. The acceptance and rejection can be viewed by the user through that log in or even by the email id.

Approval and Rejemailon by In-charge

The role of seminar hall in-charge is to check the request came to the seminar hall. When in-charges login into their account the list of new requests are displayed in their page as shown. The request can be either accepted or rejected based on the priority of the request. If more than one request is made for the same seminar hall on the same date after granting approval to a particular request by seminar hall in-charge, the remaining requests are automatically rejected and the email is sent to the bookie and also it is notified on their page.

Module – IV: Role of Principal

The Principal can view the entire process which is happening on the website and can fetch the data from the past to present who all are used the seminar hall. In an emergency case, he can reject the accepted request and the email will be sent to the booker as well as the seminar hall in-charge by suggesting alternate seminar halls.

User Registration Form

This form contains new user Registration Fields. Admin will take the role of this process to register user details. Here all the fields are validated using JavaScript Validation.


Signup Form

Login Form
The user can enter username and password. These Fields are mandatory. Both fields are validated using PHP. Login option given separated for four types of users.

Checking Availability

To check the availability of the seminar hall by Booker

Checking the availability
Availability Details
Seminar hall Booking FormIt contains all required fields for booking seminar halls like booking date, session, Booker name, dept, etc., Here all the fields are validated using JavaScript validation. For date picker, we are using ‘jQuery Date Picker’.

It contains all required fields for booking seminar halls like booking date, session, booker name, dept, etc., Here all the fields are validated using JavaScript validation. For date picker, we are using ‘jQuery Date Picker’.

Booking Form

Booking suggestion form

OUTPUT DESIGN

It contains a list of users on this system.

Administrator portal

Seminar hall Incharge Portal

It lists out the request came for the seminar hall with Booker details.In-charges approve the request based on the priority based on First Come First Serve order based on booking id or booking date and time.

Seminar hall in-charge portal

Usage details
It is Users availability checking page. On this user can check the availability of particular seminar halls.

Usage details

User page-Request details

It contains a list of requests have been sent to the seminar halls, viewed by the Head of the Departments.

Rejection of Acceptance

Notification of Approval Rejection

Usage details –principal portal

From this page, Principal can view the entire process which is happening on the website and can fetch the data from the past to present who all are used the seminar hall.

Acceptance rejection page

It shows the acceptance rejection page details, it can be viewed by principal

Admin portal

Principal portal

SYSTEM IMPLEMENTATION

The project is developed and hosted in our Engineering College web server. It is going to use by our college. Users can access this website by using the intranet. It helps users by reducing manual works. It will be a User-friendly website.

CONCLUSION

The project entitled “Seminar Hall and Auditorium Booking System” was successfully executed.  This system replaces the existing system with more features.  The system provides security to user documents.

However, the possibilities for innovation are infinite and scope for development is innumerable. The future extension can be made to provide more option in this application.

FUTURE ENHANCEMENT

Good amount of user friendliness has been incorporated in this system. It is possible to exploit these features to get the details of not only seminar hall but also the total number of blocks and which contains the total list of the hall in a block wise.  The process is suitable to extend the kind of task and the number of more process.

Download Seminar Hall booking System PHP project.

Easy Resource Utilization System

This Easy Resource Utilization System project aims to development of booking seminar halls and auditoriums in our college through online. It reduces the traditional/manual maintenance system. It creates a user-friendly website for users.

Here, four types of users are available like Principal, Administrator, Seminar hall in-charge and Head of Departments or Booker. Booker can check seminar hall availability, booking and viewing the status through online. Any faculty can reserve the seminar hall and auditorium based on the availability.

In this system, the seminar hall in-charges can view the requests and accept the request(s) according to the priority and also view the usage reports and status for a particular period. Administrator plays a vital role to maintain complete details of all the users, hall details and he/she is the only authorized person to update all details.

The principal can view all user details and usage details of seminar halls. Other users can only view the details of the seminar halls. Each event like seminar hall booking, cancellation of seminar hall will be intimated to the concern seminar hall in-charge, bookie, and Heads of the department through E-mail. Ultimately this project helps to utilize the seminar hall in an easy way.

PROJECT OVERVIEW

The project is developed for the requirement of our Kongu Engineering College. It is used to book the seminar hall through the online. Four roles are available for this project i.e., Principal, Administrator, Seminar hall In-charge and Hod. Booker can reserve the conference/seminar halls and auditorium easily.

Hall in-charges can accept and reject request came for the seminar hall. The principal can view the entire user, in-charge and usage details and he can reject the approval of hall in-charge. The administrator is responsible for users and hall details maintenance.

The project is developed and hosted in our Kongu Engineering College web server and linked to www.kongu.edu.

In the first step, the administrator has to provide the user id, password for the principal, seminar hall in-charges, Hod’s in order to avoid unwanted users to access the file, the second step Booker can book the seminar hall which is required, third step is hall in-charge can approve/reject the request of Booker. The final step is principal can view the usage details of the hall and also he has the rights to cancel the approval of hall in-charge which is accepted.

OBJECTIVES

• It is mainly to implement for departments to book seminar hall through online instead of carrying out documents and maintaining it.
• To reduce the effort of maintaining documents of seminar hall usage.
• It is the effective way of using the college resources properly.

SYSTEM ANALYSIS

EXISTING SYSTEM

This seminar hall booking is done only through the process on paper which means the process done through manual maintenance system.

Drawbacks

• Checking availability of seminar halls.
• Checking the capacity of seminar halls.
• Viewing the detail of the seminar halls.
• Phone conversations with seminar hall in-charges.
• Time wastage for the Booker.
• Mental stress to the booker.
• Non-availability of the technician.
• Booking form maintenance by the in-charge.

PROPOSED SYSTEM

This application entirely based on the online process as we can view the status of all seminar halls. It mainly reduces the effort and time of the Booker and hall in-charge. Based on the priority of request hall in-charges can easily accept or reject the request.

FEASIBILITY STUDY

This application is proposed by our principal as it is a valid one, which is a must for Kongu Engineering College as for the seminar hall booking process. This is efficiently done and helpful for all the faculty and HOD of the entire department. The drawbacks mentioned above in the current/ existing system will not reflect the proposed system.

SYSTEM SPECIFICATIONS

HARDWARE REQUIREMENTS

Processor: Intel Pentium i3 1.3 GHz
RAM: 4 GB
Hard Disk: 320 GB
Monitor: 17inch color display
Key Board: standard 104 Keys
Mouse: 4Button Scroll

SOFTWARE REQUIREMENTS

Operation System: Windows 7
Front End : HTML, PHP
Back End: MySQL
Scripting Languages: JavaScript and jQuery, PHP
Web server: XAMPP server 1.8.1

DATABASE DESIGN