How to generate employee attendance salary calculation module through PHP and Vue-PHP Tutorial-php.cn

How to generate employee attendance salary calculation module through PHP and Vue

WBOY

Release： 2023-09-25 09:30:02

Original

582 people have browsed it

How to generate employee attendance salary calculation module through PHP and Vue

Overview:
In every enterprise, employee attendance and salary calculation are one Very important work. In order to simplify and automate this process, we can use PHP and Vue.js to create a salary calculation module for employee attendance. This article will introduce how to use these two tools to achieve this function, and provide specific code examples.

Step 1: Create a database
First, we need to create a database to store employees' attendance records and salary information. Databases can be created and managed using MySQL or other database management systems. The following is an example of a simple employee table and attendance record table:

Employee table (employee):

id: Employee ID
Name: Employee name
Salary (salary): Employee salary

Attendance record sheet (attendance):

id: Record ID
Employee ID (employee_id): Employee ID
Date (date): Attendance date
Working time (start_time): Working time
Ending time (end_time): Working time

Step 2: Create back-end API
Use PHP to implement the back-end API and provide interaction with the database. The following is a sample code to obtain employee attendance records:

<?php
// 数据库连接信息
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

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

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

// 获取员工考勤记录
$sql = "SELECT * FROM attendance";
$result = $conn->query($sql);

// 将结果转化为JSON格式并输出
$res = [];
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $res[] = $row;
    }
}
echo json_encode($res);

// 关闭数据库连接
$conn->close();
?>

Copy after login

Step 3: Create a front-end page
Use Vue.js to create a front-end page for displaying employee attendance records and calculating salary. The following is a sample code for a simple employee attendance record page:

<html>
<head>
    <title>员工考勤记录</title>
    <script src="https://cdn.jsdelivr.net/npm/vue/dist/vue.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/axios/dist/axios.min.js"></script>
</head>
<body>
    <div id="app">
        <h1>员工考勤记录</h1>
        <table>
            <thead>
                <tr>
                    <th>ID</th>
                    <th>姓名</th>
                    <th>日期</th>
                    <th>上班时间</th>
                    <th>下班时间</th>
                </tr>
            </thead>
            <tbody>
                <tr v-for="record in attendanceRecords">
                    <td>{{ record.id }}</td>
                    <td>{{ record.name }}</td>
                    <td>{{ record.date }}</td>
                    <td>{{ record.start_time }}</td>
                    <td>{{ record.end_time }}</td>
                </tr>
            </tbody>
        </table>
        <button @click="calculateSalary">计算薪资</button>
        <div v-if="calculateSalaryResult">
            <p>薪资：{{ calculateSalaryResult }}</p>
        </div>
    </div>
    <script>
        // 创建Vue实例
        new Vue({
            el: '#app',
            data: {
                attendanceRecords: [],
                calculateSalaryResult: null
            },
            mounted() {
                // 获取员工考勤记录
                axios.get('api.php')
                    .then(response => {
                        this.attendanceRecords = response.data;
                    })
                    .catch(error => {
                        console.log(error);
                    });
            },
            methods: {
                calculateSalary() {
                    // 计算薪资的逻辑在这里实现
                    // 可以从this.attendanceRecords中获取考勤记录，并进行相应的计算
                    // 最后将计算结果赋值给this.calculateSalaryResult
                }
            }
        });
    </script>
</body>
</html>

Copy after login

As can be seen from the above code example, Vue.js is used to render and display data, while PHP is used to provide the back-end interface of the data. In the page, we use the axios library to send HTTP requests to obtain back-end data, and save the response results to the data attribute of the Vue instance. Finally, we trigger the logic of calculating salary through the click event of the button.

Summary:
Through PHP and Vue.js we can easily create a salary calculation module for employee attendance. Using the PHP back-end API to interact with the database, and then using the Vue.js front-end framework to display data and implement calculation logic can greatly simplify the process of attendance and salary calculation. The code example provided above is just a simple demonstration. In actual projects, more detailed implementation and functional expansion are required based on specific needs.

The above is the detailed content of How to generate employee attendance salary calculation module through PHP and Vue. For more information, please follow other related articles on the PHP Chinese website!