dbxContentContextHelpProvision.class.php

Go to the documentation of this file.

<?php
namespace dbx\dbxContent;
 
require_once __DIR__ . '/dbxContent_bootstrap_sync.php';
require_once __DIR__ . '/dbxContentContextHelp.class.php';
require_once dirname(__DIR__, 2) . '/dbxAdmin/include/dbxAdminHelp.class.php';
 
class dbxContentContextHelpProvision {
 
   private const PROVISION_VERSION = 5;
   private const CONFIG_KEY = 'context_help_provision_version';
 
   public static function run(): void {
      $version = (int) dbx()->get_config('dbxContent', self::CONFIG_KEY);
      if ($version >= self::PROVISION_VERSION) {
         return;
      }
 
      $db = dbx()->get_system_obj('dbxDB');
      if (!is_object($db)) {
         return;
      }
 
      $server = 'dbx|dbxContent.db3';
      if (!$db->connect_db_server($server)) {
         return;
      }
 
      $result = self::provisionAll($db);
      if (empty($result['errors']) && ((int) ($result['created'] ?? 0) + (int) ($result['updated'] ?? 0)) > 0) {
         self::markProvisioned();
      }
   }
 
   public static function provisionAll($db): array {
      $result = array('folders' => 0, 'created' => 0, 'updated' => 0, 'skipped' => 0, 'errors' => array());
      if (!is_object($db)) {
         $result['errors'][] = 'Keine DB-Verbindung.';
         return $result;
      }
 
      $helpFolderId = self::ensureHelpFolder($db, $result);
      if ($helpFolderId <= 0) {
         return $result;
      }
 
      $help = new \dbx\dbxAdmin\dbxAdminHelp();
 
      $contextHelp = new dbxContentContextHelp();
      $tplDir = dirname(__DIR__, 2) . '/dbxAdmin/tpl/htm/';
      $dd = dbxContentLng::ddContent();
      $sorter = self::nextContentSorter($db, $helpFolderId);
 
      foreach ($help->topics() as $topic => $meta) {
         if (!is_array($meta)) {
            continue;
         }
 
         $permalink = $contextHelp->permalinkForTopic((string) $topic);
         if ($permalink === '') {
            $result['errors'][] = 'Permalink fuer Topic ' . $topic . ' leer.';
            continue;
         }
 
         $tplName = trim((string) ($meta['tpl'] ?? ''));
         $title = trim((string) ($meta['title'] ?? $topic));
         $content = self::loadTemplateHtml($tplDir, $tplName);
         if ($content === '') {
            $result['errors'][] = 'Template fehlt: ' . $tplName;
            continue;
         }
 
         $existing = $db->select1($dd, array('permalink' => $permalink), 'id,content', 0);
         $groupRead = in_array($topic, array('consent_privacy', 'impressum'), true) ? '*' : 'admin';
         $pageData = self::pageData($helpFolderId, $title, $permalink, $content, $sorter, $groupRead);
 
         if (is_array($existing) && (int) ($existing['id'] ?? 0) > 0) {
            $id = (int) $existing['id'];
            unset($pageData['sorter']);
            if ($db->update($dd, $pageData, $id, 0, 1, 1, 0) === 1) {
               dbxContentLngSync::afterPageSave($db, $id, false);
               self::syncPermalinkIndex($db, $id, $permalink, $groupRead);
               $result['updated']++;
            } else {
               $result['errors'][] = 'Update fehlgeschlagen: ' . $permalink;
            }
            continue;
         }
 
         if ($db->insert($dd, $pageData, 0, 1, 0, 0) !== 1) {
            $result['errors'][] = 'Insert fehlgeschlagen: ' . $permalink;
            continue;
         }
 
         $id = (int) $db->get_insert_id();
         if ($id <= 0) {
            $result['errors'][] = 'Keine ID nach Insert: ' . $permalink;
            continue;
         }
 
         dbxContentLngSync::afterPageSave($db, $id, true);
         self::syncPermalinkIndex($db, $id, $permalink, $groupRead);
         $result['created']++;
         $sorter = self::nextSorterAfter($sorter);
      }
 
      if (dbxContentPageCache::isEnabled()) {
         dbxContentPageCache::invalidateAll();
      }
 
      return $result;
   }
 
   private static function markProvisioned(): void {
      $config = dbx()->get_config('dbxContent');
      if (!is_array($config)) {
         $config = array();
      }
      $config[self::CONFIG_KEY] = self::PROVISION_VERSION;
      dbx()->set_config('dbxContent', $config);
   }
 
   private static function ensureHelpFolder($db, array &$result): int {
      $outsideId = self::findFolderByName($db, 'outside', 0);
      if ($outsideId <= 0) {
         $outsideId = self::insertFolder($db, 'outside', 0, 'admin', $result);
      }
      if ($outsideId <= 0) {
         $result['errors'][] = 'Ordner outside konnte nicht angelegt werden.';
         return 0;
      }
 
      $helpId = self::findFolderByName($db, 'help', $outsideId);
      if ($helpId <= 0) {
         $helpId = self::insertFolder($db, 'help', $outsideId, 'parent', $result);
      }
      if ($helpId <= 0) {
         $result['errors'][] = 'Ordner help konnte nicht angelegt werden.';
         return 0;
      }
 
      return $helpId;
   }
 
   private static function findFolderByName($db, string $name, int $parentId): int {
      $dd = dbxContentLng::ddFolder();
      $name = trim($name);
      $parentId = (int) $parentId;
      $where = "name = '" . str_replace("'", "''", $name) . "' AND parent_id = " . $parentId;
      $rows = $db->select($dd, $where, 'id', 'id', 'ASC', '', 1, 0, 0);
      if (!is_array($rows) || !isset($rows[0]['id'])) {
         return 0;
      }
      return (int) $rows[0]['id'];
   }
 
   private static function insertFolder($db, string $name, int $parentId, string $groupRead, array &$result): int {
      $parentId = (int) $parentId;
      $sorter = self::nextFolderSorter($db, $parentId);
      $data = array(
         'name' => $name,
         'parent_id' => $parentId,
         'sorter' => $sorter,
         'group_read' => $groupRead,
         'template' => $parentId > 0 ? 'parent' : 'c-content',
         'hero_template' => $parentId > 0 ? 'parent' : 'image-hero',
         'hero_image_id' => 'parent',
         'hero_margin_top' => 'parent',
         'hero_height' => 'parent',
         'hero_variant' => 'parent',
         'hero_sticky' => 'parent',
         'hero_scroll_layer' => 'parent',
      );
 
      if ($db->insert(dbxContentLng::ddFolder(), $data, 0, 1, 0, 0) !== 1) {
         return 0;
      }
 
      $id = (int) $db->get_insert_id();
      if ($id > 0) {
         dbxContentLngSync::afterFolderSave($db, $id, true);
         $result['folders']++;
      }
      return $id;
   }
 
   private static function pageData(int $folderId, string $title, string $permalink, string $content, string $sorter, string $groupRead = 'admin'): array {
      return array(
         'activ' => 1,
         'folder' => $folderId,
         'title' => substr($title, 0, 254),
         'permalink' => substr($permalink, 0, 254),
         'description' => '',
         'keywords' => '',
         'group_read' => $groupRead,
         'sorter' => $sorter,
         'template' => 'parent',
         'hero_template' => 'parent',
         'hero_image_id' => 'parent',
         'hero_margin_top' => 'parent',
         'hero_height' => 'parent',
         'hero_variant' => 'parent',
         'hero_sticky' => 'parent',
         'hero_scroll_layer' => 'parent',
         'gallery_template' => 'image-gallery',
         'gallery_visible_count' => '3',
         'gallery_image_size' => 'original',
         'gallery_lightbox_width' => '100vw',
         'gallery_overflow' => 'grid',
         'gallery_click_behavior' => 'lightbox',
         'content' => $content,
      );
   }
 
   private static function loadTemplateHtml(string $tplDir, string $tplName): string {
      $tplName = trim($tplName);
      if ($tplName === '') {
         return '';
      }
      $path = rtrim($tplDir, '/\\') . DIRECTORY_SEPARATOR . $tplName . '.htm';
      if (!is_file($path) || !is_readable($path)) {
         return '';
      }
      $html = file_get_contents($path);
      return is_string($html) ? trim($html) : '';
   }
 
   private static function syncPermalinkIndex($db, int $cid, string $permalink, string $rights = 'admin'): void {
      $cid = (int) $cid;
      $permalink = dbxContentPermalinkIndex::normalizePermalink($permalink);
      if ($cid <= 0 || $permalink === '') {
         return;
      }
      dbxContentPermalinkIndex::upsertPage($cid, $permalink, $rights, 1);
   }
 
   private static function nextContentSorter($db, int $folderId): string {
      $folderId = (int) $folderId;
      $rows = $db->select(dbxContentLng::ddContent(), 'folder = ' . $folderId, 'sorter', 'sorter,id', 'DESC', '', 1, 0, 0);
      $max = 0;
      if (is_array($rows) && isset($rows[0]) && is_array($rows[0])) {
         $max = (int) ($rows[0]['sorter'] ?? 0);
      }
      return sprintf('%04d', $max + 10);
   }
 
   private static function nextFolderSorter($db, int $parentId): string {
      $parentId = (int) $parentId;
      $rows = $db->select(dbxContentLng::ddFolder(), 'parent_id = ' . $parentId, 'sorter', 'sorter,id', 'DESC', '', 1, 0, 0);
      $max = 0;
      if (is_array($rows) && isset($rows[0]) && is_array($rows[0])) {
         $max = (int) ($rows[0]['sorter'] ?? 0);
      }
      return sprintf('%04d', $max + 10);
   }
 
   private static function nextSorterAfter(string $sorter): string {
      $num = (int) $sorter;
      return sprintf('%04d', $num + 10);
   }
}