PHPを使用して開発した従業員給与管理モジュールをERPシステムに適用

CREATE TABLE employees (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255),
    salary_grade INT,
    position VARCHAR(255),
    ... // 其他基本信息字段
);

<?php
// 连接数据库
$servername = "localhost";
$username = "root";
$password = "123456";
$dbname = "erp";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接失败：" . $conn->connect_error);
}

// 录入员工信息
$name = $_POST["name"];
$salary_grade = $_POST["salary_grade"];
$position = $_POST["position"];

$sql = "INSERT INTO employees (name, salary_grade, position)
        VALUES ('$name', '$salary_grade', '$position')";

if ($conn->query($sql) === TRUE) {
    echo "员工信息录入成功";
} else {
    echo "录入失败：" . $conn->error;
}

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

<?php
// 连接数据库
$servername = "localhost";
$username = "root";
$password = "123456";
$dbname = "erp";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接失败：" . $conn->connect_error);
}

// 查询员工的薪资等级
$id = $_POST["id"];

$sql = "SELECT salary_grade FROM employees WHERE id = '$id'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    $salary_grade = $row["salary_grade"];

    // 根据薪资等级和工作情况计算员工的薪水
    $salary = calculate_salary($salary_grade);

    // 更新员工的薪水字段
    $sql = "UPDATE employees SET salary = '$salary' WHERE id = '$id'";
    if ($conn->query($sql) === TRUE) {
        echo "薪酬计算成功";
    } else {
        echo "计算失败：" . $conn->error;
    }
} else {
    echo "查询失败";
}

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

// 计算薪水的函数
function calculate_salary($salary_grade) {
    // 根据薪资等级和工作情况进行计算
    ...
    return $salary;
}
?>

<?php
// 连接数据库
$servername = "localhost";
$username = "root";
$password = "123456";
$dbname = "erp";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接失败：" . $conn->connect_error);
}

// 录入员工福利信息
$id = $_POST["id"];
$allowance = $_POST["allowance"];
// 其他福利字段

$sql = "UPDATE employees SET allowance = '$allowance' WHERE id = '$id'";

if ($conn->query($sql) === TRUE) {
    echo "福利信息录入成功";
} else {
    echo "录入失败：" . $conn->error;
}

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

<?php
// 连接数据库
$servername = "localhost";
$username = "root";
$password = "123456";
$dbname = "erp";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接失败：" . $conn->connect_error);
}

// 录入奖惩记录
$id = $_POST["id"];
$reward = $_POST["reward"];
$punishment = $_POST["punishment"];

$sql = "UPDATE employees SET reward = '$reward', punishment = '$punishment' WHERE id = '$id'";

if ($conn->query($sql) === TRUE) {
    echo "奖惩记录成功";
} else {
    echo "记录失败：" . $conn->error;
}

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

<?php
// 连接数据库
$servername = "localhost";
$username = "root";
$password = "123456";
$dbname = "erp";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接失败：" . $conn->connect_error);
}

// 生成薪酬统计报表
$sql = "SELECT COUNT(*) AS total_employees, SUM(salary) AS total_salary FROM employees";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    $total_employees = $row["total_employees"];
    $total_salary = $row["total_salary"];

    echo "总员工数：" . $total_employees . "<br>";
    echo "总薪水：" . $total_salary;
} else {
    echo "查询失败";
}

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