dbxContent_sections.class.php

Go to the documentation of this file.

<?php
namespace dbx\dbxContent_admin;
 
dbx()->use_system_class('dbxReport');
require_once dirname(__DIR__, 2) . '/dbxContent/include/dbxContent_bootstrap_sync.php';
 
use dbx\dbxContent\dbxContentLng;
use dbx\dbxContent\dbxContentLngSync;
use dbx\dbxContent\dbxContentPageCache;
 
class dbxReport_ContentSections extends \dbxReport {
 
   public function run_body($content) {
      $record = $this->_record;
      $path = trim((string)($record['path'] ?? ''));
 
      if ($path !== '') {
         $url = '?dbx_modul=dbxEditor&dbx_run1=edit&file=' . rawurlencode($path);
         $record['edit'] =
            '<a class="btn btn-outline-primary btn-sm dbx-win" href="' . htmlspecialchars($url, ENT_QUOTES, 'UTF-8') . '" ' .
            'data-url="' . htmlspecialchars($url, ENT_QUOTES, 'UTF-8') . '" data-title="Content Template bearbeiten" ' .
            'title="Template bearbeiten"><i class="bi bi-pencil"></i></a>';
      }
 
      $editUrl = trim((string)($record['edit_url'] ?? ''));
      if ($editUrl !== '') {
         $record['edit'] =
            '<a class="btn btn-outline-primary btn-sm" href="' . htmlspecialchars($editUrl, ENT_QUOTES, 'UTF-8') . '" ' .
            'title="Im Content CMS bearbeiten"><i class="bi bi-pencil"></i></a>';
      }
 
      $this->_record = $record;
      return $this->forward_run_body($content);
   }
}
 
class dbxContent_sections {
 
   private $content_folders = array();
   private $media_usages = array();
 
   private function render_section($title, $subtitle, $content, $barActions = '') {
      return dbx()->get_system_obj('dbxTPL')->get_tpl('dbxContent_admin|content-admin-section', array(
         'title' => $title,
         'subtitle' => $subtitle,
         'content' => $content,
         'bar_actions' => $barActions,
      ));
   }
 
   private function is_ajax_request() {
      return (int)dbx()->get_system_var('dbx_ajax', 0, 'int') === 1;
   }
 
   private function render_section_or_ajax($title, $subtitle, $content, $barActions = '') {
      if ($this->is_ajax_request()) {
         return $content;
      }
 
      return $this->render_section($title, $subtitle, $content, $barActions);
   }
 
   private function base_url($action, $params = array()) {
      $url = '?dbx_modul=dbxContent_admin&dbx_run1=content&dbx_run2=' . rawurlencode((string)$action);
      foreach ($params as $key => $value) {
         $url .= '&' . rawurlencode((string)$key) . '=' . rawurlencode((string)$value);
      }
      return $url;
   }
 
   private function request_json() {
      $raw = file_get_contents('php://input');
      $data = $raw ? json_decode($raw, true) : array();
      return is_array($data) ? $data : array();
   }
 
   private function content_grid_folder_editor_values() {
      if (!$this->content_folders) {
         $db = dbx()->get_system_obj('dbxDB');
         $this->load_content_folders_map($db);
      }
 
      $pairs = array('0=/');
      $folderIds = array_keys($this->content_folders);
      usort($folderIds, function ($a, $b) {
         return strcmp($this->content_folder_path($a), $this->content_folder_path($b));
      });
 
      foreach ($folderIds as $folderId) {
         $path = $this->content_folder_path($folderId);
         $label = str_replace(array('~', '=', ';'), array(' ', ' ', ' '), $path);
         $pairs[] = (int)$folderId . '=' . $label;
      }
 
      return implode('~', $pairs);
   }
 
   private function content_grid_cols() {
      $folderValues = $this->content_grid_folder_editor_values();
 
      return implode(',', array(
         'id[ID]:number:p:width=72;hozAlign=center;headerHozAlign=center',
         'title[Titel]:text::width=240',
         'permalink[Permalink]:text::width=200',
         'folder[Ordner]:text::editor=list;values=' . $folderValues . ';width=220',
         'activ[Aktiv]:text::editor=list;values=0=Inaktiv~1=Aktiv;width=110',
         'update_date[Geaendert]:text:p:width=170',
      ));
   }
 
   private function load_content_folders_map($db) {
      $folderRows = $db->select(
         dbxContentLng::ddFolder(),
         '',
         'id,name,parent_id',
         'id',
         'ASC',
         '',
         0,
         0,
         0
      );
      $this->content_folders = array();
      if (is_array($folderRows)) {
         foreach ($folderRows as $folderRow) {
            $folderId = (int)($folderRow['id'] ?? 0);
            if ($folderId > 0) {
               $this->content_folders[$folderId] = $folderRow;
            }
         }
      }
   }
 
   private function enrich_content_row(array $row) {
      $row['folder_path'] = $this->content_folder_path($row['folder'] ?? 0);
      if (isset($row['update_date'])) {
         $row['update_date'] = preg_replace('/\.\d+$/', '', trim((string)$row['update_date']));
      }
      $id = (int)($row['id'] ?? 0);
      if ($id > 0) {
         $row['profile_link'] = $this->base_url('edit', array('cid' => $id)) . '&dbx_window=1';
         $row['show_link'] = '?dbx_modul=dbxContent&dbx_run1=show&dbx_cid=' . $id . '&dbx_window=1';
      }
      return $row;
   }
 
   private function grid_sort_from_request() {
      $rsort = 'id';
      $rdesc = 'DESC';
      $allowed = array('id', 'title', 'permalink', 'activ', 'update_date', 'folder');
      $sort = dbx()->get_request_var('dbx_sorters', '', '*');
      if ($sort) {
         $sorters = json_decode($sort, true);
         if (is_array($sorters) && isset($sorters[0]['field'])) {
            $field = (string)$sorters[0]['field'];
            if (in_array($field, $allowed, true)) {
               $rsort = $field;
               $rdesc = strtolower((string)($sorters[0]['dir'] ?? 'asc')) === 'desc' ? 'DESC' : 'ASC';
            }
         }
      }
      return array($rsort, $rdesc);
   }
 
   private function content_grid_read() {
      $db = dbx()->get_system_obj('dbxDB');
      $dd = dbxContentLng::ddContent();
      $this->load_content_folders_map($db);
 
      $page = (int)dbx()->get_request_var('page', 0, 'int');
      $size = (int)dbx()->get_request_var('size', 0, 'int');
 
      $search = dbx()->get_request_var('dbx_search', '', 'sqlsearch|max=128');
      $where = $db->build_search_where($dd, $search, array('title', 'permalink'), array('id'), 'contains');
      list($rsort, $rdesc) = $this->grid_sort_from_request();
 
      $flds = array('id', 'title', 'permalink', 'folder', 'activ', 'update_date');
 
      if ($page > 0 && $size > 0) {
         $size = max(1, min(200, $size));
         $rpos = ($page - 1) * $size;
         $count = (int)$db->count($dd, $where);
         $rows = $db->select($dd, $where, $flds, $rsort, $rdesc, '', $size, $rpos);
      } else {
         $rows = $db->select($dd, $where, $flds, $rsort, $rdesc, '', 0, 0);
         $count = is_array($rows) ? count($rows) : 0;
      }
      if (!is_array($rows)) {
         $rows = array();
      }
 
      $out = array();
      foreach ($rows as $row) {
         if (!is_array($row)) {
            continue;
         }
         $out[] = $this->enrich_content_row($row);
      }
 
      $count = (int)$count;
      $last_page = ($page > 0 && $size > 0) ? max(1, (int)ceil($count / $size)) : 1;
 
      dbx()->json_response(array(
         'ok' => 1,
         'count' => $count,
         'last_page' => $last_page,
         'last_row' => $count,
         'rows' => $out,
         'server_time' => (new \DateTime())->format('Y-m-d H:i:s.v'),
      ), true);
   }
 
   private function content_grid_sync() {
      $db = dbx()->get_system_obj('dbxDB');
      $dd = dbxContentLng::ddContent();
      $this->load_content_folders_map($db);
 
      $last_update = trim((string)dbx()->get_request_var('last_update', ''));
      if ($last_update === '') {
         $last_update = trim((string)dbx()->get_modul_var('last_update', ''));
      }
      if ($last_update === '') {
         $last_update = '1970-01-01 00:00:00';
      }
 
      $where = "update_date > '" . str_replace("'", "''", $last_update) . "'";
      $flds = array('id', 'title', 'permalink', 'folder', 'activ', 'update_date');
      $rows = $db->select($dd, $where, $flds, 'update_date', 'ASC', '', 0, 0);
      if (!is_array($rows)) {
         $rows = array();
      }
 
      $out = array();
      foreach ($rows as $row) {
         if (!is_array($row)) {
            continue;
         }
         $out[] = $this->enrich_content_row($row);
      }
 
      dbx()->json_response(array(
         'ok' => 1,
         'count' => count($out),
         'rows' => $out,
         'server_time' => (new \DateTime())->format('Y-m-d H:i:s.v'),
      ), true);
   }
 
   private function content_grid_save() {
      $db = dbx()->get_system_obj('dbxDB');
      $cms = dbx()->get_include_obj('dbxContent_cms');
      if (is_object($cms) && method_exists($cms, 'ensure_schema')) {
         $cms->ensure_schema($db);
      }
 
      $payload = $this->request_json();
      $rows = is_array($payload['rows'] ?? null) ? $payload['rows'] : array();
      $dd = dbxContentLng::ddContent();
      $allowed = array_flip(array('title', 'permalink', 'activ', 'folder'));
      $saved = array();
 
      $this->load_content_folders_map($db);
 
      foreach ($rows as $row) {
         if (!is_array($row)) {
            continue;
         }
         $id = (int)($row['id'] ?? 0);
         if ($id <= 0) {
            continue;
         }
 
         $data = array();
         foreach ($allowed as $field => $_) {
            if (!array_key_exists($field, $row)) {
               continue;
            }
            if ($field === 'activ' || $field === 'folder') {
               $data[$field] = (int)$row[$field];
            } else {
               $data[$field] = trim((string)$row[$field]);
            }
         }
         if (!$data) {
            continue;
         }
 
         if (array_key_exists('folder', $data)) {
            $folderId = (int)$data['folder'];
            if ($folderId < 0 || ($folderId > 0 && !isset($this->content_folders[$folderId]))) {
               continue;
            }
         }
 
         if ($db->update($dd, $data, $id) >= 0) {
            dbxContentLngSync::afterPageSave($db, $id, false);
            dbxContentPageCache::invalidateContent($id);
            dbxContentPageCache::invalidateAllMenus();
            $fresh = $db->select1($dd, $id, 'id,title,permalink,folder,activ,update_date', 0);
            if (is_array($fresh)) {
               $saved[] = $this->enrich_content_row($fresh);
            }
         }
      }
 
      $this->load_content_folders_map($db);
 
      dbx()->json_response(array(
         'ok' => 1,
         'success' => true,
         'rows' => $saved,
      ), true);
   }
 
   private function content_grid_delete() {
      $payload = $this->request_json();
      $id = (int)($payload['id'] ?? 0);
      if ($id <= 0) {
         dbx()->json_response(array('ok' => 0, 'success' => false, 'msg' => 'Keine Seiten-ID.'), true);
      }
 
      $cms = dbx()->get_include_obj('dbxContent_cms');
      $result = is_object($cms) ? $cms->delete_page_record($id) : array('ok' => 0, 'errors' => array('CMS nicht verfuegbar.'));
      $errors = is_array($result['errors'] ?? null) ? $result['errors'] : array();
 
      dbx()->json_response(array(
         'ok' => (int)($result['ok'] ?? 0),
         'success' => (int)($result['ok'] ?? 0) === 1,
         'msg' => implode(' ', $errors),
      ), true);
   }
 
   private function report_content_grid() {
      $oReport = dbx()->get_system_obj('dbxReport');
      $db = dbx()->get_system_obj('dbxDB');
      $dd = dbxContentLng::ddContent();
      $all = (int)$db->count($dd);
      $active = (int)$db->count($dd, 'activ = 1');
 
      $oReport->init('content-admin-content-grid', 'content-admin-content-grid');
      $oReport->add_rep('shell_panel_class', 'dbx-grid dbx-content-list-grid');
      $oReport->add_rep('frame_use_form', '0');
      $oReport->add_rep('bar_title', 'Content');
      $oReport->add_rep('bar_subtitle', 'Seiten der aktuell gewaehlten Sprache.');
      $oReport->_mode = 'tabulurator';
      $oReport->_rrows = 600;
      $oReport->_grid_id = 'dbx_content_list_grid';
      $oReport->_grid_cols = $this->content_grid_cols();
      $oReport->_grid_layout = 'fitDataStretch';
      $oReport->_grid_read_url = $this->base_url('content_grid_read');
      $oReport->_grid_save_url = $this->base_url('content_grid_save');
      $oReport->_grid_delete_url = $this->base_url('content_grid_delete');
      $oReport->_grid_sync_url = $this->base_url('content_grid_sync');
      $oReport->_grid_synctime = '1.5';
      $oReport->add_grid_stats(array(
         array('label' => 'Seiten', 'value' => (string)$all),
         array('label' => 'Aktiv', 'value' => (string)$active, 'tone' => 'ok'),
         array('label' => 'Inaktiv', 'value' => (string)max(0, $all - $active)),
      ), 'Content Kennzahlen');
      $oReport->add_obj('bar_actions', 'obj-value',
         '<a class="btn btn-outline-primary btn-sm" href="' . dbx()->esc($this->base_url('edit')) . '">' .
         '<i class="bi bi-pencil-square"></i><span>Content CMS</span></a>'
      );
 
      return $oReport->run();
   }
 
   private function report_rows($action, array $fields, array $rows, $msgSuccess = '', $msgError = '') {
      $report = new dbxReport_ContentSections();
      $report->init('content-admin-report');
      $report->_action = '?dbx_modul=dbxContent_admin&dbx_run1=content&dbx_run2=' . rawurlencode($action);
      $report->_create_sel_flds = 0;
      $report->_rflds = $fields;
      $report->_mode = 'table';
      $report->_rdata = $rows;
      $report->_rcount = count($rows);
      $report->_rrows = count($rows) > 0 ? count($rows) : 1;
      $report->_rpos = 0;
 
      if ($msgSuccess !== '') {
         $report->_msg_success = $msgSuccess;
      }
      if ($msgError !== '') {
         $report->_msg_error = $msgError;
      }
 
      if ($action === 'list_folder') {
         $report->set_callback_owner($this);
         $report->set_callback('next_record', 'folder_next_record');
         $report->set_callback('row_action_data', 'folder_row_action_data');
         $report->_create_row_edit = 1;
         $report->_create_row_delete = 1;
         $report->_msg_confirm_delete = 'Diesen Content-Ordner wirklich loeschen?';
         $report->set_tabel_tpl('tpl_row_edit', 'modul|content-admin-row-edit');
      } elseif ($action === 'list_media') {
         $report->set_callback_owner($this);
         $report->set_callback('next_record', 'media_next_record');
         $report->set_callback('row_action_data', 'media_row_action_data');
         $report->_create_row_delete = 1;
         $report->_msg_confirm_delete = 'Dieses Medium wirklich loeschen?';
         $report->set_tabel_tpl('tpl_row_delete', 'modul|content-admin-row-delete-media');
      } elseif ($action === 'templates') {
         $report->set_callback_owner($this);
         $report->set_callback('row_action_data', 'template_row_action_data');
         $report->_create_row_edit = 1;
         $report->_create_row_delete = 1;
         $report->_fld_id = 'name';
         $report->_msg_confirm_delete = 'Template-Datei wirklich loeschen?';
         $report->_rpt_format['modified'] = 'php-datetime-usr';
         $report->_table_buttons = 'left';
         $report->set_tabel_tpl('tpl_row_edit', 'modul|content-admin-row-edit');
         $report->set_tabel_tpl('tpl_row_delete', 'modul|content-admin-row-delete-template');
      }
 
      return $report->run();
   }
 
   private function content_folder_path($folderId) {
      $folderId = (int)$folderId;
      if ($folderId <= 0) {
         return '/';
      }
 
      $parts = array();
      $seen = array();
 
      while ($folderId > 0 && isset($this->content_folders[$folderId]) && !isset($seen[$folderId])) {
         $seen[$folderId] = true;
         $folder = $this->content_folders[$folderId];
         $name = trim((string)($folder['name'] ?? ''), " \t\n\r\0\x0B/");
 
         if ($name !== '') {
            array_unshift($parts, $name);
         }
 
         $parentId = (int)($folder['parent_id'] ?? 0);
         if ($parentId === $folderId) {
            break;
         }
         $folderId = $parentId;
      }
 
      return '/' . implode('/', $parts);
   }
 
   public function content_next_record($report, $record) {
      if (!is_array($record)) {
         return $record;
      }
 
      $record['folder_path'] = $this->content_folder_path($record['folder'] ?? 0);
      if (isset($record['update_date'])) {
         $record['update_date'] = preg_replace('/\.\d+$/', '', trim((string)$record['update_date']));
      }
      return $record;
   }
 
   public function content_row_action_data($report, $data) {
      if (!is_array($data) || !isset($data['data']) || !is_array($data['data'])) {
         return $data;
      }
 
      $type = (string)($data['type'] ?? '');
      $rid = (int)($data['data']['rid'] ?? 0);
 
      if ($type === 'edit') {
         $url = '?dbx_modul=dbxContent_admin&dbx_run1=content&dbx_run2=edit&cid=' . $rid . '&dbx_window=1';
         $data['data']['action'] = $url;
         $data['data']['edit_url'] = htmlspecialchars($url, ENT_QUOTES, 'UTF-8');
         $data['data']['edit_title'] = htmlspecialchars('Content im CMS bearbeiten', ENT_QUOTES, 'UTF-8');
         $data['data']['class'] = 'openWin';
      } elseif ($type === 'delete') {
         $data['data']['action'] =
            '?dbx_modul=dbxContent_admin&dbx_run1=content&dbx_run2=list_content';
      }
 
      return $data;
   }
 
   public function media_next_record($report, $record) {
      if (!is_array($record)) {
         return $record;
      }
 
      $id = (int)($record['id'] ?? 0);
      $type = strtolower(trim((string)($record['media_type'] ?? '')));
      $provider = strtolower(trim((string)($record['provider'] ?? '')));
      $providerId = trim((string)($record['provider_id'] ?? ''));
      $title = trim((string)($record['title'] ?? $record['file_name'] ?? 'Medium'));
      $preview = '<span class="text-muted"><i class="bi bi-file-earmark"></i></span>';
 
      if ($id > 0 && in_array($type, array('image', 'video', 'external_video'), true)) {
         $mediaUrl = 'index.php?dbx_modul=dbxContent&dbx_run1=media&dbx_mid=' . $id;
         $url = '?dbx_modul=dbxContent_admin&dbx_run1=media_view&rid=' . $id . '&dbx_window=1';
         $thumbUrl = $mediaUrl . '&dbx_thumb=1';
         if ($type === 'external_video' && $provider === 'youtube' && preg_match('/^[A-Za-z0-9_-]{11}$/', $providerId)) {
            $thumbUrl = 'https://img.youtube.com/vi/' . rawurlencode($providerId) . '/hqdefault.jpg';
         }
         $preview =
            '<a class="openWin dbx-win" href="' . htmlspecialchars($url, ENT_QUOTES, 'UTF-8') . '" ' .
            'data-url="' . htmlspecialchars($url, ENT_QUOTES, 'UTF-8') . '" ' .
            'data-title="' . htmlspecialchars($title, ENT_QUOTES, 'UTF-8') . '" ' .
            'title="' . htmlspecialchars($title, ENT_QUOTES, 'UTF-8') . '">' .
            '<img src="' . htmlspecialchars($thumbUrl, ENT_QUOTES, 'UTF-8') . '" ' .
            'alt="' . htmlspecialchars($title, ENT_QUOTES, 'UTF-8') . '" loading="lazy" ' .
            'class="rounded border bg-light" style="width:96px;height:64px;object-fit:cover">' .
            '</a>';
      }
 
      $record['thumbnail'] = $preview;
      $usages = $this->media_usages[$id] ?? array();
      $usageHtml = array();
      foreach ($usages as $usage) {
         $lng = strtolower(trim((string)($usage['lng'] ?? '')));
         $usageId = (int)($usage['id'] ?? 0);
         $type = (string)($usage['type'] ?? 'page');
         $label = trim((string)($usage['title'] ?? ''));
         $url = '?dbx_modul=dbxContent_admin&dbx_run1=cms&dbx_lng=' . rawurlencode($lng) .
            ($type === 'folder' ? '&fid=' : '&cid=') . $usageId . '&dbx_window=1';
         $usageHtml[] =
            '<a class="openWin dbx-win d-block text-decoration-none mb-1" ' .
            'href="' . htmlspecialchars($url, ENT_QUOTES, 'UTF-8') . '" ' .
            'data-url="' . htmlspecialchars($url, ENT_QUOTES, 'UTF-8') . '" ' .
            'data-title="' . htmlspecialchars($label, ENT_QUOTES, 'UTF-8') . '" ' .
            'title="' . htmlspecialchars($label, ENT_QUOTES, 'UTF-8') . '">' .
            '<span class="badge text-bg-secondary me-1">' . htmlspecialchars(strtoupper($lng), ENT_QUOTES, 'UTF-8') . '</span>' .
            htmlspecialchars($label, ENT_QUOTES, 'UTF-8') .
            '</a>';
      }
      $record['usage'] = count($usageHtml)
         ? implode('', $usageHtml)
         : '<span class="text-muted">Nicht verwendet</span>';
      $record['_usage_count'] = count($usages);
      return $record;
   }
 
   public function media_row_action_data($report, $data) {
      if (!is_array($data) || !isset($data['data']) || !is_array($data['data'])) {
         return $data;
      }
 
      if ((string)($data['type'] ?? '') !== 'delete') {
         return $data;
      }
 
      $rid = (int)($data['data']['rid'] ?? 0);
      $used = count($this->media_usages[$rid] ?? array()) > 0;
      $data['data']['delete_url'] =
         '?dbx_modul=dbxContent_admin&dbx_run1=content&dbx_run2=list_media&dbx_do=row_delete&rid=' . $rid;
      $data['data']['delete_class'] = $used ? 'disabled text-muted' : 'dbxAjax dbxConfirm text-danger';
      $data['data']['delete_title'] = $used
         ? 'Medium wird verwendet und kann nicht geloescht werden'
         : 'Medium loeschen';
      $data['data']['delete_disabled'] = $used ? 'aria-disabled="true" tabindex="-1"' : '';
      $data['data']['confirm'] = $report->_msg_confirm_delete;
 
      return $data;
   }
 
   private function add_media_usage(array &$map, int $mediaId, string $lng, int $id, string $title, string $type = 'page'): void {
      if ($mediaId <= 0 || $id <= 0 || $lng === '') {
         return;
      }
 
      $key = $type . '|' . $lng . '|' . $id;
      $map[$mediaId][$key] = array(
         'lng' => $lng,
         'id' => $id,
         'title' => ($type === 'folder' ? 'Ordner: ' : '') . ($title !== '' ? $title : ('#' . $id)),
         'type' => $type,
      );
   }
 
   private function load_media_usages($db): array {
      $map = array();
      $usageRows = $db->select('dbxMediaUsage', 'active = 1', 'media_id,content_id,folder_id', 'media_id,id', 'ASC', '', 0, 0, 0);
      $usageRows = is_array($usageRows) ? $usageRows : array();
 
      foreach (dbxContentLngSync::accessibleLngs() as $lng) {
         $lng = strtolower(trim((string)$lng));
         if ($lng === '') {
            continue;
         }
 
         $pages = $db->select(
            dbxContentLng::ddContent($lng),
            '',
            'id,title,hero_image_id,content',
            'id',
            'ASC',
            '',
            0,
            0,
            0
         );
         $folders = $db->select(
            dbxContentLng::ddFolder($lng),
            '',
            'id,name,hero_image_id',
            'id',
            'ASC',
            '',
            0,
            0,
            0
         );
 
         $pagesById = array();
         foreach (is_array($pages) ? $pages : array() as $page) {
            $pageId = (int)($page['id'] ?? 0);
            if ($pageId <= 0) {
               continue;
            }
            $pagesById[$pageId] = $page;
 
            $heroId = (int)($page['hero_image_id'] ?? 0);
            if ($heroId > 0) {
               $this->add_media_usage($map, $heroId, $lng, $pageId, (string)($page['title'] ?? ''), 'page');
            }
            if (preg_match_all('/data-cms-media-id=["\']?(\d+)/i', (string)($page['content'] ?? ''), $matches)) {
               foreach ($matches[1] as $mediaId) {
                  $this->add_media_usage($map, (int)$mediaId, $lng, $pageId, (string)($page['title'] ?? ''), 'page');
               }
            }
         }
 
         $foldersById = array();
         foreach (is_array($folders) ? $folders : array() as $folder) {
            $folderId = (int)($folder['id'] ?? 0);
            if ($folderId <= 0) {
               continue;
            }
            $foldersById[$folderId] = $folder;
            $heroId = (int)($folder['hero_image_id'] ?? 0);
            if ($heroId > 0) {
               $this->add_media_usage($map, $heroId, $lng, $folderId, (string)($folder['name'] ?? ''), 'folder');
            }
         }
 
         foreach ($usageRows as $usage) {
            $mediaId = (int)($usage['media_id'] ?? 0);
            $contentId = (int)($usage['content_id'] ?? 0);
            $folderId = (int)($usage['folder_id'] ?? 0);
            if ($contentId > 0 && isset($pagesById[$contentId])) {
               $this->add_media_usage(
                  $map,
                  $mediaId,
                  $lng,
                  $contentId,
                  (string)($pagesById[$contentId]['title'] ?? ''),
                  'page'
               );
            } elseif ($folderId > 0 && isset($foldersById[$folderId])) {
               $this->add_media_usage(
                  $map,
                  $mediaId,
                  $lng,
                  $folderId,
                  (string)($foldersById[$folderId]['name'] ?? ''),
                  'folder'
               );
            }
         }
      }
 
      foreach ($map as $mediaId => $items) {
         $map[$mediaId] = array_values($items);
      }
      return $map;
   }
 
   public function folder_next_record($report, $record) {
      if (!is_array($record)) {
         return $record;
      }
 
      $record['folder_path'] = $this->content_folder_path($record['id'] ?? 0);
      return $record;
   }
 
   public function folder_row_action_data($report, $data) {
      if (!is_array($data) || !isset($data['data']) || !is_array($data['data'])) {
         return $data;
      }
 
      $type = (string)($data['type'] ?? '');
      $rid = (int)($data['data']['rid'] ?? 0);
 
      if ($type === 'edit') {
         $url = '?dbx_modul=dbxContent_admin&dbx_run1=cms&fid=' . $rid . '&dbx_window=1';
         $data['data']['action'] = $url;
         $data['data']['edit_url'] = htmlspecialchars($url, ENT_QUOTES, 'UTF-8');
         $data['data']['edit_title'] = htmlspecialchars('Content-Ordner im CMS bearbeiten', ENT_QUOTES, 'UTF-8');
         $data['data']['class'] = 'openWin';
      } elseif ($type === 'delete') {
         $data['data']['action'] =
            '?dbx_modul=dbxContent_admin&dbx_run1=content&dbx_run2=list_folder';
      }
 
      return $data;
   }
 
   private function report_content() {
      return $this->report_content_grid();
   }
 
   private function report_folders() {
      $db = dbx()->get_system_obj('dbxDB');
 
      $deleteId = (int)dbx()->get_modul_var('rid', 0, 'int');
      if (dbx()->get_modul_var('dbx_do', '', 'parameter') === 'row_delete' && $deleteId > 0) {
         $cms = dbx()->get_include_obj('dbxContent_cms');
         $cms->delete_folder_record($deleteId);
      }
 
      $fields = array(
         'id' => 'ID',
         'folder_path' => 'Ordner',
         'template' => 'Template',
         'group_read' => 'Leserechte',
      );
 
      $rows = $db->select(
         dbxContentLng::ddFolder(),
         '',
         'id,name,parent_id,template,group_read',
         'name',
         'ASC',
         '',
         0,
         0,
         0
      );
      if (!is_array($rows)) {
         $rows = array();
      }
 
      $this->content_folders = array();
      foreach ($rows as $index => $row) {
         $folderId = (int)($row['id'] ?? 0);
         if ($folderId > 0) {
            $this->content_folders[$folderId] = $row;
         }
         $rows[$index]['folder_path'] = '';
      }
 
      return $this->report_rows('list_folder', $fields, $rows);
   }
 
   private function report_media() {
      $db = dbx()->get_system_obj('dbxDB');
 
      $this->media_usages = $this->load_media_usages($db);
      $deleteId = (int)dbx()->get_modul_var('rid', 0, 'int');
      if (dbx()->get_modul_var('dbx_do', '', 'parameter') === 'row_delete' && $deleteId > 0) {
         $cms = dbx()->get_include_obj('dbxContent_cms');
         $cms->delete_media_record($deleteId);
         $this->media_usages = $this->load_media_usages($db);
      }
 
      $fields = array(
         'thumbnail' => 'Vorschau',
         'id' => 'ID',
         'title' => 'Titel',
         'media_type' => 'Typ',
         'media_folder' => 'Ordner',
         'provider' => 'Provider',
         'usage' => 'Verwendung',
         'active' => 'Aktiv',
      );
 
      $rows = $db->select(
         'dbxMedia',
         '',
         'id,title,media_type,file_name,media_folder,provider,provider_id,active',
         'id',
         'DESC',
         '',
         0,
         0,
         0
      );
      if (!is_array($rows)) {
         $rows = array();
      }
 
      foreach ($rows as $index => $row) {
         $rows[$index]['thumbnail'] = '';
         $rows[$index]['usage'] = '';
      }
 
      return $this->report_rows('list_media', $fields, $rows);
   }
 
   private function media_view() {
      $id = (int)dbx()->get_modul_var('rid', 0, 'int');
      $db = dbx()->get_system_obj('dbxDB');
      $row = $id > 0 ? $db->select1('dbxMedia', $id) : array();
 
      if (!is_array($row) || !count($row)) {
         return dbx()->get_system_obj('dbxTPL')->get_tpl('dbx|alert-warning', array(
            'msg' => 'Medium nicht gefunden.',
         ));
      }
 
      $type = strtolower(trim((string)($row['media_type'] ?? 'file')));
      $provider = strtolower(trim((string)($row['provider'] ?? '')));
      $providerId = trim((string)($row['provider_id'] ?? ''));
      $title = trim((string)($row['title'] ?? $row['file_name'] ?? ('Medium #' . $id)));
      $mime = trim((string)($row['mime'] ?? ''));
      $mediaUrl = 'index.php?dbx_modul=dbxContent&dbx_run1=media&dbx_mid=' . $id;
      $mediaHtml = '';
 
      if ($type === 'image') {
         $mediaHtml =
            '<img src="' . htmlspecialchars($mediaUrl, ENT_QUOTES, 'UTF-8') . '" ' .
            'alt="' . htmlspecialchars($title, ENT_QUOTES, 'UTF-8') . '" ' .
            'class="img-fluid rounded border bg-light" style="max-height:72vh;object-fit:contain">';
      } elseif ($type === 'video') {
         $poster = !empty($row['thumb_file_path'])
            ? ' poster="' . htmlspecialchars($mediaUrl . '&dbx_thumb=1', ENT_QUOTES, 'UTF-8') . '"'
            : '';
         $mediaHtml =
            '<video class="w-100 rounded border bg-dark" style="max-height:72vh" controls preload="metadata" playsinline' . $poster . '>' .
            '<source src="' . htmlspecialchars($mediaUrl, ENT_QUOTES, 'UTF-8') . '"' .
            ($mime !== '' ? ' type="' . htmlspecialchars($mime, ENT_QUOTES, 'UTF-8') . '"' : '') . '>' .
            'Ihr Browser kann dieses Video nicht wiedergeben.</video>';
      } elseif ($type === 'external_video' && $provider === 'youtube' && preg_match('/^[A-Za-z0-9_-]{11}$/', $providerId)) {
         $embedUrl = 'https://www.youtube.com/embed/' . rawurlencode($providerId);
         $mediaHtml =
            '<div class="ratio ratio-16x9"><iframe src="' . htmlspecialchars($embedUrl, ENT_QUOTES, 'UTF-8') . '" ' .
            'title="' . htmlspecialchars($title, ENT_QUOTES, 'UTF-8') . '" ' .
            'allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" ' .
            'allowfullscreen></iframe></div>';
      } else {
         $mediaHtml =
            '<div class="text-center py-5"><i class="bi bi-file-earmark fs-1 d-block mb-3"></i>' .
            '<a class="btn btn-primary" href="' . htmlspecialchars($mediaUrl, ENT_QUOTES, 'UTF-8') . '">' .
            '<i class="bi bi-box-arrow-up-right"></i> Datei anzeigen</a></div>';
      }
 
      return dbx()->get_system_obj('dbxTPL')->get_tpl('dbxContent_admin|content-admin-media-view', array(
         'title' => htmlspecialchars($title, ENT_QUOTES, 'UTF-8'),
         'media' => $mediaHtml,
         'type' => htmlspecialchars($type, ENT_QUOTES, 'UTF-8'),
         'folder' => htmlspecialchars((string)($row['media_folder'] ?? ''), ENT_QUOTES, 'UTF-8'),
         'mime' => htmlspecialchars($mime, ENT_QUOTES, 'UTF-8'),
         'id' => (string)$id,
      ));
   }
 
   public function template_row_action_data($report, $data) {
      if (!is_array($data) || !isset($data['data']) || !is_array($data['data'])) {
         return $data;
      }
 
      $record = is_array($data['record'] ?? null) ? $data['record'] : array();
      $type = (string)($data['type'] ?? '');
      $tpl = trim((string)($record['name'] ?? ''));
 
      if ($type === 'edit') {
         $modul = trim((string)($record['modul'] ?? 'dbxContent'));
         $fileType = trim((string)($record['type'] ?? 'htm'));
 
         $relPath = 'dbx/modules/' . $modul . '/tpl/' . $fileType . '/' . $tpl . '.' . $fileType;
         $url = '?dbx_modul=dbxEditor&dbx_run1=edit&file=' . rawurlencode($relPath) . '&dbx_window=1';
 
         $data['data']['action'] = $url;
         $data['data']['edit_url'] = htmlspecialchars($url, ENT_QUOTES, 'UTF-8');
         $data['data']['edit_title'] = htmlspecialchars($modul . '|' . $tpl, ENT_QUOTES, 'UTF-8');
         $data['data']['class'] = 'openWin';
      } elseif ($type === 'delete' && $tpl !== '') {
         $data['data']['delete_url'] =
            '?dbx_modul=dbxContent_admin&dbx_run1=content&dbx_run2=templates&dbx_do=row_delete&rid=' .
            rawurlencode($tpl);
         $data['data']['delete_class'] = 'dbxAjax dbxConfirm text-danger';
         $data['data']['delete_title'] = 'Template loeschen';
         $data['data']['delete_disabled'] = '';
         $data['data']['confirm'] = $report->_msg_confirm_delete;
      }
 
      return $data;
   }
 
   private function template_dir() {
      return dbx_os_path_file(dbx_get_base_dir() . 'dbx/modules/dbxContent/tpl/htm/');
   }
 
   private function normalize_template_name($name) {
      $name = trim((string)$name);
      $name = preg_replace('/\.htm$/i', '', $name);
 
      if ($name !== '' && stripos($name, 'c-') !== 0) {
         $name = 'c-' . $name;
      }
 
      if ($name === '' || !preg_match('/^c-[a-zA-Z0-9][a-zA-Z0-9_-]*$/', $name)) {
         return '';
      }
 
      return $name;
   }
 
   private function template_file_path($name) {
      $name = $this->normalize_template_name($name);
      if ($name === '') {
         return '';
      }
 
      $dir = rtrim($this->template_dir(), '/\\') . DIRECTORY_SEPARATOR;
      if (!is_dir($dir)) {
         return '';
      }
 
      return $dir . $name . '.htm';
   }
 
   private function default_template_markup() {
      return <<<'HTML'
<article id="dbx_target_{i}" class="c-cms default">
 
  <div class="title">
    <h1>{cms:title}</h1>
  </div>
 
  <section class="cms-hero {cms:hero_class}" style="{hero:style}">
    <div class="hero">{cms:hero}<div class="hero-text">{cms:hero_text}</div></div>
  </section>
 
  <section class="cms-header header">{cms:header}</section>
 
  <section class="gallery {cms:gallery_class}">
    <div class="gallery-list"
         style="{gallery:style}"{gallery:data_dbx}>{cms:gallery}</div>
  </section>
 
  <section class="cols cols-{cms:cols}">
    <div class="col col-1">{cms:col1}</div>
    <div class="col col-2">{cms:col2}</div>
    <div class="col col-3">{cms:col3}</div>
  </section>
 
  <footer class="footer">{cms:footer}</footer>
 
</article>
 
HTML;
   }
 
   private function delete_template_file($name) {
      $path = $this->template_file_path($name);
      if ($path === '' || !is_file($path)) {
         return false;
      }
 
      return @unlink($path);
   }
 
   private function create_template_file($name) {
      $name = $this->normalize_template_name($name);
      if ($name === '') {
         return array('ok' => false, 'msg' => 'Ungueltiger Template-Name. Erlaubt: c-name mit Buchstaben, Zahlen, Bindestrich, Unterstrich.');
      }
 
      $path = $this->template_file_path($name);
      if ($path === '') {
         return array('ok' => false, 'msg' => 'Template-Pfad konnte nicht ermittelt werden.');
      }
 
      if (is_file($path)) {
         return array('ok' => false, 'msg' => 'Template existiert bereits: ' . $name . '.htm');
      }
 
      $bytes = @file_put_contents($path, $this->default_template_markup());
      if ($bytes === false) {
         return array('ok' => false, 'msg' => 'Template konnte nicht angelegt werden.');
      }
 
      return array('ok' => true, 'msg' => 'Template angelegt: ' . $name . '.htm', 'name' => $name);
   }
 
   private function templates_bar_actions() {
      $url = '?dbx_modul=dbxContent_admin&dbx_run1=content&dbx_run2=template_new&dbx_window=1';
 
      return '<a class="btn btn-primary btn-sm openWin dbx-win" href="' . htmlspecialchars($url, ENT_QUOTES, 'UTF-8') . '" ' .
         'data-url="' . htmlspecialchars($url, ENT_QUOTES, 'UTF-8') . '" ' .
         'data-title="Neues Content-Template" title="Neues c-* Template anlegen">' .
         '<i class="bi bi-plus-lg"></i> Neues Template</a>';
   }
 
   private function template_new() {
      $tpl = dbx()->get_system_obj('dbxTPL');
      $action = '?dbx_modul=dbxContent_admin&dbx_run1=content&dbx_run2=template_new';
      $msg = '';
      $templateName = '';
 
      if (dbx()->get_request_var('dbx_do', '', 'parameter') === 'template_create') {
         $templateName = trim((string)dbx()->get_request_var('template_name', '', 'parameter'));
         $result = $this->create_template_file($templateName);
 
         if (!empty($result['ok'])) {
            return dbx()->redirect('?dbx_modul=dbxContent_admin&dbx_run1=content&dbx_run2=templates');
         }
 
         $msg = $tpl->get_tpl('dbx|alert-danger', array(
            'msg' => (string)($result['msg'] ?? 'Template konnte nicht angelegt werden.'),
         ));
      }
 
      return $tpl->get_tpl('dbxContent_admin|content-admin-template-new', array(
         'action' => $action,
         'template_name' => htmlspecialchars($templateName, ENT_QUOTES, 'UTF-8'),
         'msg' => $msg,
      ));
   }
 
   private function report_templates() {
      $msgSuccess = '';
      $msgError = '';
      $dbxDo = (string)dbx()->get_request_var('dbx_do', '', 'alphanum');
      $deleteName = trim((string)dbx()->get_request_var('rid', '', 'alphanum'));
      if ($dbxDo === 'row_delete' && $deleteName !== '') {
         if ($this->delete_template_file($deleteName)) {
            $msgSuccess = 'Template geloescht: ' . $deleteName . '.htm';
         } else {
            $msgError = 'Template konnte nicht geloescht werden.';
         }
      }
 
      $dir = $this->template_dir();
      $files = is_dir($dir) ? glob($dir . '*.htm') : array();
      $rows = array();
 
      if (is_array($files)) {
         sort($files, SORT_NATURAL | SORT_FLAG_CASE);
         foreach ($files as $file) {
            if (!is_file($file)) {
               continue;
            }
 
            $name = pathinfo($file, PATHINFO_FILENAME);
            if (stripos($name, 'c-') !== 0) {
               continue;
            }
 
            $rows[] = array(
               'modul' => 'dbxContent',
               'name' => $name,
               'type' => pathinfo($file, PATHINFO_EXTENSION),
               'size' => (string)filesize($file),
               'modified' => date('Y-m-d H:i:s', filemtime($file)),
            );
         }
      }
 
      $fields = array(
         'modul' => 'Modul',
         'name' => 'Template',
         'type' => 'Typ',
         'size' => 'Bytes',
         'modified' => 'Geaendert',
      );
 
      return $this->report_rows('templates', $fields, $rows, $msgSuccess, $msgError);
   }
 
   public function run($work = '') {
      switch ($work) {
         case 'content_grid_read':
            $this->content_grid_read();
            break;
 
         case 'content_grid_save':
            $this->content_grid_save();
            break;
 
         case 'content_grid_delete':
            $this->content_grid_delete();
            break;
 
         case 'content_grid_sync':
            $this->content_grid_sync();
            break;
 
         case 'list_content':
            return $this->report_content();
 
         case 'list_folder':
            return $this->render_section(
               'Ordner',
               'Content-Ordner der aktuell gewaehlten Sprache.',
               $this->report_folders()
            );
 
         case 'list_media':
            return $this->render_section(
               'Medien',
               'Zentrale Medien aus dbxMedia.',
               $this->report_media()
            );
 
         case 'media_view':
            return $this->media_view();
 
         case 'templates':
            return $this->render_section_or_ajax(
               'Content Templates',
               'Verfuegbare Templates aus dbxContent/tpl/htm.',
               $this->report_templates(),
               $this->templates_bar_actions()
            );
 
         case 'template_new':
            return $this->template_new();
      }
 
      return dbx()->get_system_obj('dbxTPL')->get_tpl('dbx|alert-warning', array(
         'msg' => 'Content-Bereich (' . dbx()->html($work) . ') ist nicht definiert.',
      ));
   }
}
 
?>