initialize('mgr'); $modx->setLogLevel(xPDO::LOG_LEVEL_INFO); $modx->setLogTarget('ECHO'); echo "
\n";

// ── 1. Charger le package xPDO ────────────────────────────────────────────
$corePath = $modx->getOption('core_path') . 'components/audit_express/';
$modx->addPackage('audit_express', $corePath . 'model/');

// Générer les tables à partir du schéma XML
$manager   = $modx->getManager();
$generator = $manager->getGenerator();

// Créer la table (ignore si elle existe déjà)
$result = $manager->createObjectContainer('AuditRequest');
if ($result) {
    echo "[OK] Table `audit_requests` créée.\n";
} else {
    echo "[INFO] Table `audit_requests` déjà existante ou erreur silencieuse.\n";
}

// ── 2. System Settings ────────────────────────────────────────────────────
$settings = [
    'ae.core_path'      => $corePath,
    'ae.resource.landing'  => '',
    'ae.resource.select'   => '',
    'ae.resource.quiz'     => '',
    'ae.resource.optional' => '',
    'ae.resource.results'  => '',
    'ae.resource.pdf'      => '',
    'ae.booking_url'    => 'https://calendly.com/livinweb/diagnostic',
    'ae.devis_url'      => 'mailto:contact@livinweb.fr',
];

foreach ($settings as $key => $value) {
    $existing = $modx->getObject('modSystemSetting', ['key' => $key]);
    if (!$existing) {
        $setting = $modx->newObject('modSystemSetting');
        $setting->fromArray([
            'key'       => $key,
            'value'     => $value,
            'xtype'     => 'textfield',
            'namespace' => 'audit_express',
            'area'      => 'ae_settings',
        ]);
        $setting->save();
        echo "[OK] Setting créé : $key\n";
    } else {
        echo "[SKIP] Setting existant : $key\n";
    }
}

// ── 3. SQL de fallback ────────────────────────────────────────────────────
$tablePrefix = $modx->getOption('table_prefix', null, 'modx_');
$sql = <<\n";