PHPを利用した保守管理機能を提供するERP(Enterprise Resource Planning)システムの開発

CREATE TABLE equipment (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL,
    serial_number VARCHAR(255) NOT NULL,
    manufacturer VARCHAR(255),
    status ENUM('正常','维修中','报废') DEFAULT '正常',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE work_order (
    id INT PRIMARY KEY AUTO_INCREMENT,
    equipment_id INT NOT NULL,
    description TEXT,
    scheduled_date DATE,
    status ENUM('未派单','已派单','已完成') DEFAULT '未派单',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (equipment_id) REFERENCES equipment(id)
);

CREATE TABLE maintenance_record (
    id INT PRIMARY KEY AUTO_INCREMENT,
    work_order_id INT NOT NULL,
    technician VARCHAR(255),
    start_date DATETIME,
    end_date DATETIME,
    description TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (work_order_id) REFERENCES work_order(id)
);

class Equipment {
    private $db;

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

    public function createEquipment($name, $serial_number, $manufacturer) {
        $sql = "INSERT INTO equipment (name, serial_number, manufacturer) VALUES ('$name', '$serial_number', '$manufacturer')";
        $this->db->query($sql);
    }

    public function updateEquipmentStatus($id, $status) {
        $sql = "UPDATE equipment SET status = '$status' WHERE id = $id";
        $this->db->query($sql);
    }

    // 其他设备相关操作...
}

class WorkOrder {
    private $db;

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

    public function createWorkOrder($equipment_id, $description, $scheduled_date) {
        $sql = "INSERT INTO work_order (equipment_id, description, scheduled_date) VALUES ($equipment_id, '$description', '$scheduled_date')";
        $this->db->query($sql);
    }

    public function assignWorkOrder($id, $technician) {
        $sql = "UPDATE work_order SET status = '已派单', technician = '$technician' WHERE id = $id";
        $this->db->query($sql);
    }

    // 其他工单相关操作...
}

$db = new mysqli('localhost', 'username', 'password', 'database_name');
$equipment = new Equipment($db);
$workOrder = new WorkOrder($db);

// 创建设备
$equipment->createEquipment('设备1', 'SN001', '制造商A');

// 创建维修工单
$workOrder->createWorkOrder(1, '设备1需要维修', '2022-01-01');

// 派发工单
$workOrder->assignWorkOrder(1, '张三');

// 更新设备状态
$equipment->updateEquipmentStatus(1, '维修中');

// 其他相关操作...