How to use PHP to write an employee attendance data re-entry program?

How to use PHP to write an employee attendance data re-entry program?

With the continuous development of information technology, more and more companies are beginning to use electronic methods to manage employee attendance to improve efficiency and accuracy. However, in actual operations, there are always some special circumstances that prevent the attendance data of some employees from being entered into the system in time. This requires us to write an employee attendance data supplementary entry program to solve this problem. This article will introduce in detail how to write such a program using PHP and provide specific code examples for reference.

1. Requirements Analysis
Before starting to write the program, we must first conduct a needs analysis to determine what functions the employee attendance data re-entry program we write needs to have. Generally speaking, this program needs to include at least the following functions:

1. Employee information management: including the entry and query functions of basic information such as employee names, job numbers, departments, etc.;
2. Attendance data Re-enrollment: Ability to enter employee absences and lateness, and record re-enrollment personnel and re-enrollment time;
3. Re-enrollment data query: Ability to query re-enrollment attendance data based on employee name or job number;
4. Data statistics and analysis: It can perform statistics and analysis on supplementary attendance data, such as calculating the total number of absences and tardiness of an employee.

2. Database design
Before we start writing code, we need to design the database structure to store employee information and attendance data. Suppose our database is named "attendance" and contains two tables: employee table (employee) and attendance table (Attendance).

The fields of the employee table include: employee ID (id), name (name), employee number (employee_number), department (department), etc.

The fields of the attendance table include: attendance ID (id), employee ID (employee_id), number of absences (absent_times), number of late arrivals (late_times), supplementary personnel (rescuer), supplementary time (rescue_time), etc. .

3. Code writing

1. ##Employee information management:

   // 添加员工信息
   function addEmployee($name, $employee_number, $department) {
    // 连接到数据库
    $conn = mysqli_connect("localhost", "root", "password", "attendance");
    // 插入数据
    $sql = "INSERT INTO employee (name, employee_number, department) VALUES ('$name', '$employee_number', '$department')";
    mysqli_query($conn, $sql);
    // 关闭数据库连接
    mysqli_close($conn);
   }
   
   // 查询员工信息
   function searchEmployee($name) {
    $conn = mysqli_connect("localhost", "root", "password", "attendance");
    $sql = "SELECT * FROM employee WHERE name = '$name'";
    $result = mysqli_query($conn, $sql);
    $data = mysqli_fetch_assoc($result);
    mysqli_close($conn);
    return $data;
   }

   Copy after login

2. Attendance data supplementary entry:

   // 录入考勤数据
   function addAttendance($employee_id, $absent_times, $late_times, $rescuer, $rescue_time) {
    $conn = mysqli_connect("localhost", "root", "password", "attendance");
    $sql = "INSERT INTO Attendance (employee_id, absent_times, late_times, rescuer, rescue_time) VALUES ('$employee_id', '$absent_times', '$late_times', '$rescuer', '$rescue_time')";
    mysqli_query($conn, $sql);
    mysqli_close($conn);
   }

   Copy after login

3. Supplementary data query:

   // 根据员工姓名查询补录的考勤数据
   function searchAttendanceByName($name) {
    $conn = mysqli_connect("localhost", "root", "password", "attendance");
    $sql = "SELECT * FROM Attendance INNER JOIN employee ON Attendance.employee_id = employee.id WHERE employee.name = '$name'";
    $result = mysqli_query($conn, $sql);
    $data = mysqli_fetch_assoc($result);
    mysqli_close($conn);
    return $data;
   }
   
   // 根据员工工号查询补录的考勤数据
   function searchAttendanceByNumber($employee_number) {
    $conn = mysqli_connect("localhost", "root", "password", "attendance");
    $sql = "SELECT * FROM Attendance INNER JOIN employee ON Attendance.employee_id = employee.id WHERE employee.employee_number = '$employee_number'";
    $result = mysqli_query($conn, $sql);
    $data = mysqli_fetch_assoc($result);
    mysqli_close($conn);
    return $data;
   }

   Copy after login

4. Data statistics and analysis:

   // 统计某个员工的总缺勤次数
   function getTotalAbsentTimes($employee_id) {
    $conn = mysqli_connect("localhost", "root", "password", "attendance");
    $sql = "SELECT SUM(absent_times) AS total_absent_times FROM Attendance WHERE employee_id = '$employee_id'";
    $result = mysqli_query($conn, $sql);
    $data = mysqli_fetch_assoc($result);
    mysqli_close($conn);
    return $data['total_absent_times'];
   }
   
   // 统计某个员工的总迟到次数
   function getTotalLateTimes($employee_id) {
    $conn = mysqli_connect("localhost", "root", "password", "attendance");
    $sql = "SELECT SUM(late_times) AS total_late_times FROM Attendance WHERE employee_id = '$employee_id'";
    $result = mysqli_query($conn, $sql);
    $data = mysqli_fetch_assoc($result);
    mysqli_close($conn);
    return $data['total_late_times'];
   }

   Copy after login

After completing the code writing, we should test and perform performance optimization according to the actual situation. You can use a browser to access the written PHP file, test whether each function is normal, and pay attention to check whether there are potential security vulnerabilities.

Writing an employee attendance data re-entry program requires multiple stages such as demand analysis, database design and code writing. This article provides a sample program for readers' reference. In actual use, it can be expanded and optimized according to actual needs to make it more suitable for the actual situation of the enterprise.

The above is the detailed content of How to use PHP to write an employee attendance data re-entry program?. For more information, please follow other related articles on the PHP Chinese website!