PHP를 사용하여 조직 구조 관리 기능을 구현하는 전사적 자원 관리(ERP) 시스템 개발

CREATE TABLE departments (
    id INT(11) PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100) NOT NULL,
    parent_id INT(11),
    create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE positions (
    id INT(11) PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100) NOT NULL,
    create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE employees (
    id INT(11) PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100) NOT NULL,
    department_id INT(11),
    position_id INT(11),
    create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

<?php
// 添加部门
function addDepartment($name, $parentId = null) {
    // 在数据库中插入一条部门记录
    // ...
}

// 编辑部门
function editDepartment($id, $name) {
    // 更新数据库中对应的部门记录
    // ...
}

// 添加职位
function addPosition($name) {
    // 在数据库中插入一条职位记录
    // ...
}

// 编辑职位
function editPosition($id, $name) {
    // 更新数据库中对应的职位记录
    // ...
}

// 添加员工
function addEmployee($name, $departmentId, $positionId) {
    // 在数据库中插入一条员工记录
    // ...
}

// 编辑员工
function editEmployee($id, $name, $departmentId, $positionId) {
    // 更新数据库中对应的员工记录
    // ...
}

?>

<?php
class Department {
    private $id;
    private $name;
    private $parentId;

    // 构造函数
    public function __construct($id, $name, $parentId = null) {
        $this->id = $id;
        $this->name = $name;
        $this->parentId = $parentId;
    }

    // 获取部门ID
    public function getId() {
        return $this->id;
    }

    // 获取部门名称
    public function getName() {
        return $this->name;
    }

    // 获取父部门ID
    public function getParentId() {
        return $this->parentId;
    }
}

class Position {
    private $id;
    private $name;

    // 构造函数
    public function __construct($id, $name) {
        $this->id = $id;
        $this->name = $name;
    }

    // 获取职位ID
    public function getId() {
        return $this->id;
    }

    // 获取职位名称
    public function getName() {
        return $this->name;
    }
}

class Employee {
    private $id;
    private $name;
    private $departmentId;
    private $positionId;

    // 构造函数
    public function __construct($id, $name, $departmentId, $positionId) {
        $this->id = $id;
        $this->name = $name;
        $this->departmentId = $departmentId;
        $this->positionId = $positionId;
    }

    // 获取员工ID
    public function getId() {
        return $this->id;
    }

    // 获取员工名称
    public function getName() {
        return $this->name;
    }

    // 获取员工所属部门ID
    public function getDepartmentId() {
        return $this->departmentId;
    }

    // 获取员工所属职位ID
    public function getPositionId() {
        return $this->positionId;
    }
}

// 示例用法
$department = new Department(1, '总部');
$position = new Position(1, '经理');
$employee = new Employee(1, '张三', $department->getId(), $position->getId());

echo '员工所属部门ID：' . $employee->getDepartmentId();
echo '员工所属职位ID：' . $employee->getPositionId();

?>