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://cal.com/augustin.podvin/decouvrir-les-opportunites-suite-a-mon-audit',
'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";