How to implement employee leave approval process in PHP?

How to implement the employee leave approval process in PHP?

With the development of enterprises, human resource management has become more and more important. One of the key issues is the optimization of the employee leave management process. In order to improve efficiency and accuracy, many companies have adopted electronic approval processes to optimize employee leave management. This article will introduce how to use PHP language to implement the employee leave approval process, and attach specific code examples.

1. Create a database table

First, create a table in the MySQL database to store employee information (for example, the table name is employees), Contains fields such as employee ID, name, department, etc. In addition, you need to create a table for storing leave information (for example, the table name is leaves), including fields such as leave ID, employee ID, leave date, and leave type.

2. Write a PHP file

Next, create a PHP file named leave.php to handle the employee leave approval process. Add database connection code in the file header to connect to the MySQL database.

<?php
$servername = "localhost";
$username = "root";
$password = "your_password";
$dbname = "your_database";

// 创建数据库连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查是否连接成功
if ($conn->connect_error) {
    die("数据库连接失败: " . $conn->connect_error);
}

// 设置字符集为UTF-8
mysqli_set_charset($conn, 'utf8');
?>

3. Implementing the leave application function

In the leave.php file, write a function to process leave applicationapplyLeave(). This function is used to receive and process leave applications submitted by employees, and insert the leave information into the leaves table.

function applyLeave($employeeID, $leaveDate, $leaveType) {
    global $conn;

    $sql = "INSERT INTO leaves (employee_id, leave_date, leave_type) VALUES ('$employeeID', '$leaveDate', '$leaveType')";

    if ($conn->query($sql) === TRUE) {
        echo "请假申请已提交";
    } else {
        echo "请假申请失败";
    }
}

4. Implementing the leave approval function

In the leave.php file, write a function that handles leave approvalapproveLeave(). This function is used to receive and process the supervisor's approval results for leave applications, and update the approval status of the corresponding leave applications.

function approveLeave($leaveID, $status) {
    global $conn;

    $sql = "UPDATE leaves SET status = '$status' WHERE leave_id = '$leaveID'";

    if ($conn->query($sql) === TRUE) {
        echo "审批结果已更新";
    } else {
        echo "更新审批结果失败";
    }
}

5. Implementing leave query function

In the leave.php file, write a function to process leave querygetLeaveInfo(). This function is used to query the employee's leave information based on the employee ID.

function getLeaveInfo($employeeID) {
    global $conn;

    $sql = "SELECT * FROM leaves WHERE employee_id = '$employeeID'";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        while($row = $result->fetch_assoc()) {
            echo "请假ID: " . $row["leave_id"]. "，员工ID: " . $row["employee_id"]. "，请假日期: " . $row["leave_date"]. "<br>";
        }
    } else {
        echo "没有找到请假信息";
    }
}

6. Start the server test

Upload the leave.php file to the server and make sure the server supports PHP running. Access the leave.php file in the browser and call the corresponding function through the URL parameters to test the employee leave approval process.

For example, use the following URL parameters to test the leave application function:

http://your_domain/leave.php?func=applyLeave&employeeID=1&leaveDate=2022-01-01&leaveType=病假

Use the following URL parameters to test the approval leave function:

http://your_domain/leave.php?func=approveLeave&leaveID=1&status=已批准

Use the following URL parameters to test the query leave request Function:

http://your_domain/leave.php?func=getLeaveInfo&employeeID=1

Summary:

By using the PHP programming language, we can implement a simple and practical employee leave approval process. By writing appropriate PHP functions and combining them with MySQL database for data storage and query, the employee leave application and approval process can be effectively managed. I believe that the code examples provided in this article can help you better understand and use PHP to implement the employee leave approval process.

The above is the detailed content of How to implement employee leave approval process in PHP?. For more information, please follow other related articles on the PHP Chinese website!