PHP를 활용하여 개발된 복리후생관리 모듈을 전사적 자원관리(ERP) 시스템에 적용

class EmployeeWelfare {
  private $conn;

  public function __construct($db) {
    $this->conn = $db;
  }

  // 获取所有员工福利
  public function getAll() {
    $query = "SELECT * FROM employee_welfare";
    $stmt = $this->conn->prepare($query);
    $stmt->execute();
    return $stmt;
  }

  // 根据ID获取员工福利
  public function getById($id) {
    $query = "SELECT * FROM employee_welfare WHERE id = ?";
    $stmt = $this->conn->prepare($query);
    $stmt->bindParam(1, $id);
    $stmt->execute();
    return $stmt;
  }

  // 创建员工福利
  public function create($employee_id, $welfare_type, $start_date, $end_date) {
    $query = "INSERT INTO employee_welfare (employee_id, welfare_type, start_date, end_date) VALUES (?, ?, ?, ?)";
    $stmt = $this->conn->prepare($query);
    $stmt->bindParam(1, $employee_id);
    $stmt->bindParam(2, $welfare_type);
    $stmt->bindParam(3, $start_date);
    $stmt->bindParam(4, $end_date);
    if ($stmt->execute()) {
      return true;
    }
    return false;
  }

  // 更新员工福利
  public function update($id, $employee_id, $welfare_type, $start_date, $end_date) {
    $query = "UPDATE employee_welfare SET employee_id = ?, welfare_type = ?, start_date = ?, end_date = ? WHERE id = ?";
    $stmt = $this->conn->prepare($query);
    $stmt->bindParam(1, $employee_id);
    $stmt->bindParam(2, $welfare_type);
    $stmt->bindParam(3, $start_date);
    $stmt->bindParam(4, $end_date);
    $stmt->bindParam(5, $id);
    if ($stmt->execute()) {
      return true;
    }
    return false;
  }

  // 删除员工福利
  public function delete($id) {
    $query = "DELETE FROM employee_welfare WHERE id = ?";
    $stmt = $this->conn->prepare($query);
    $stmt->bindParam(1, $id);
    if ($stmt->execute()) {
      return true;
    }
    return false;
  }
}

$database = new Database();
$db = $database->getConnection();

$employeeWelfare = new EmployeeWelfare($db);

// 获取所有员工福利
$result = $employeeWelfare->getAll();
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
  // 处理数据
}

// 根据ID获取员工福利
$id = 1;
$result = $employeeWelfare->getById($id);
$row = $result->fetch(PDO::FETCH_ASSOC);
// 处理数据

// 创建员工福利
$employee_id = 1;
$welfare_type = '医疗保险';
$start_date = '2021-01-01';
$end_date = '2021-12-31';
if ($employeeWelfare->create($employee_id, $welfare_type, $start_date, $end_date)) {
  echo '员工福利创建成功';
} else {
  echo '员工福利创建失败';
}

// 更新员工福利
$id = 1;
$employee_id = 1;
$welfare_type = '医疗保险';
$start_date = '2022-01-01';
$end_date = '2022-12-31';
if ($employeeWelfare->update($id, $employee_id, $welfare_type, $start_date, $end_date)) {
  echo '员工福利更新成功';
} else {
  echo '员工福利更新失败';
}

// 删除员工福利
$id = 1;
if ($employeeWelfare->delete($id)) {
  echo '员工福利删除成功';
} else {
  echo '员工福利删除失败';
}