当前位置：首页 > PHP

php实现cmdb

2026-02-14 17:07:36PHP

PHP实现CMDB（配置管理数据库）方案

CMDB用于集中管理IT基础设施的配置信息，以下是基于PHP的实现方案：

数据库设计

核心表结构需包含资产类型、资产属性、关联关系等模块：

CREATE TABLE assets (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL,
    type_id INT NOT NULL,
    status ENUM('active','retired') DEFAULT 'active',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE asset_types (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100) UNIQUE NOT NULL,
    description TEXT
);

CREATE TABLE asset_fields (
    id INT PRIMARY KEY AUTO_INCREMENT,
    type_id INT NOT NULL,
    field_name VARCHAR(100) NOT NULL,
    data_type ENUM('string','number','date','boolean') NOT NULL,
    is_required BOOLEAN DEFAULT false
);

CREATE TABLE asset_values (
    asset_id INT NOT NULL,
    field_id INT NOT NULL,
    value TEXT,
    PRIMARY KEY (asset_id, field_id)
);

核心功能实现

资产模型动态管理：

class AssetModel {
    public function createType($typeName, $fields) {
        $pdo->beginTransaction();
        $stmt = $pdo->prepare("INSERT INTO asset_types (name) VALUES (?)");
        $stmt->execute([$typeName]);
        $typeId = $pdo->lastInsertId();

        foreach($fields as $field) {
            $stmt = $pdo->prepare("INSERT INTO asset_fields (...) VALUES (...)");
            $stmt->execute([...]);
        }
        $pdo->commit();
    }
}

接口设计

RESTful API基础结构：

$app->get('/api/assets/{id}', function ($request, $response, $args) {
    $asset = AssetRepository::getById($args['id']);
    return $response->withJson($asset);
});

$app->post('/api/assets', function ($request, $response) {
    $data = $request->getParsedBody();
    $validator = new AssetValidator($data);
    if ($validator->validate()) {
        $asset = AssetService::create($data);
        return $response->withJson($asset, 201);
    }
    return $response->withJson($validator->errors(), 400);
});