« Back to History
tmp_acl_debug.php
|
20260721_154033.php
Initial Bulk Import
Copy Code
<?php require __DIR__ . '/core/db.php'; $slug = 'vehicle_data_add'; function dump_rows(PDO $pdo, string $sql, array $params = []): array { $st = $pdo->prepare($sql); $st->execute($params); return $st->fetchAll(PDO::FETCH_ASSOC) ?: []; } $result = [ 'page_acl_master' => dump_rows( $pdo, "SELECT id, company_id, slug, roles_json, is_enabled FROM page_acl_master WHERE slug IN (?, ?) ORDER BY company_id DESC, id DESC", [$slug, $slug . '.php'] ), 'page_permissions' => dump_rows( $pdo, "SELECT id, company_id, slug, allow_roles, allow_user_ids, is_enabled FROM page_permissions WHERE slug IN (?, ?) ORDER BY company_id DESC, id DESC", [$slug, $slug . '.php'] ), ]; header('Content-Type: application/json'); echo json_encode($result, JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES);