PHP中将多行权限数据透视化为单行多列显示教程

<?php

// 模拟原始数据
$data = [
    ['user' => 'Jon', 'page' => 'books', 'permission' => 'read'],
    ['user' => 'Jon', 'page' => 'books', 'permission' => 'delete'],
    ['user' => 'Jon', 'page' => 'photos', 'permission' => 'read'],
    ['user' => 'Jon', 'page' => 'photos', 'permission' => 'edit'],
    ['user' => 'Jane', 'page' => 'books', 'permission' => 'read'],
    ['user' => 'Jane', 'page' => 'books', 'permission' => 'edit'],
];

$sorted = [];
foreach ($data as $row) {
    // 如果当前用户不存在，则初始化其数据结构
    if (!isset($sorted[$row['user']])) {
        $sorted[$row['user']] = [];
    }
    // 如果当前用户的当前页面不存在，则初始化其权限列表
    // 预设所有可能的权限为false，确保即使没有某个权限，该列也能被正确处理
    if (!isset($sorted[$row['user']][$row['page']])) {
        $sorted[$row['user']][$row['page']] = [
            'read'   => false,
            'edit'   => false,
            'delete' => false,
            // 如果有其他权限类型，也在这里添加并初始化
        ];
    }
    // 将实际存在的权限设置为true
    $sorted[$row['user']][$row['page']][$row['permission']] = true;
}

// $sorted 结构示例 (部分)
/*
$sorted = [
    'Jon' => [
        'books' => [
            'read'   => true,
            'edit'   => false,
            'delete' => true,
        ],
        'photos' => [
            'read'   => true,
            'edit'   => true,
            'delete' => false,
        ],
    ],
    'Jane' => [
        'books' => [
            'read'   => true,
            'edit'   => true,
            'delete' => false,
        ],
    ],
];
*/

?>

<?php

// 假设 $sorted 变量已由上述预处理步骤生成

echo '<table border="1">'; // 添加边框以便查看

// 表头
echo '<thead>';
echo '<tr>';
echo '<th>User</th>';
echo '<th>Page</th>';
echo '<th>Read</th>';
echo '<th>Edit</th>';
echo '<th>Delete</th>';
// 如果有其他权限类型，也在这里添加对应的<th>
echo '</tr>';
echo '</thead>';

echo '<tbody>';
foreach ($sorted as $user => $pages) {
    foreach ($pages as $pagename => $perms) {
        echo '<tr>';
        echo '<td>' . htmlspecialchars($user) . '</td>';
        echo '<td>' . htmlspecialchars($pagename) . '</td>';

        // 遍历权限，根据布尔值输出 'X' 或空
        echo '<td>' . ($perms['read'] ? 'X' : '') . '</td>';
        echo '<td>' . ($perms['edit'] ? 'X' : '') . '</td>';
        echo '<td>' . ($perms['delete'] ? 'X' : '') . '</td>';
        // 如果有其他权限类型，也在这里添加对应的<td>

        echo '</tr>';
    }
}
echo '</tbody>';

echo '</table>';

?>