dbxContactList.class.php

Go to the documentation of this file.

<?php
namespace dbx\dbxContact;
 
require_once __DIR__ . '/dbxContactTicket.class.php';
 
class dbxContactList {
 
   private function db() {
      return dbx()->get_system_obj('dbxDB');
   }
 
   private function tpl() {
      return dbx()->get_system_obj('dbxTPL');
   }
 
   private function h($value): string {
      return htmlspecialchars((string) $value, ENT_QUOTES, 'UTF-8');
   }
 
   private function denied(): string {
      return $this->tpl()->get_tpl('dbx|alert-warning', array(
         'msg' => 'Bitte melden Sie sich an, um Ihre Kontaktanfragen zu sehen.',
      ));
   }
 
   private function statusClass(string $status): string {
      return array(
         'open' => 'text-bg-primary',
         'in_progress' => 'text-bg-info',
         'waiting_customer' => 'text-bg-warning',
         'answered' => 'text-bg-success',
         'closed' => 'text-bg-secondary',
      )[$status] ?? 'text-bg-light';
   }
 
   private function ticketForUser(int $rid, int $uid): array {
      $ticket = dbxContactTicket::ticket($this->db(), $rid);
      if (!$ticket || !dbxContactTicket::userOwns($ticket, $uid) || (int) ($ticket['user_hidden'] ?? 0) === 1) {
         return array();
      }
      return $ticket;
   }
 
   private function excerpt($value, int $max = 120): string {
      $value = trim((string) preg_replace('/\s+/', ' ', (string) $value));
      if (strlen($value) > $max) {
         $value = substr($value, 0, $max - 3) . '...';
      }
      return $this->h($value);
   }
 
   private function decorateRows(array $rows): array {
      $out = array();
      foreach ($rows as $row) {
         $status = dbxContactTicket::normalizeStatus((string) ($row['status'] ?? 'open'));
         $row['status_view'] = '<span class="badge ' . $this->statusClass($status) . '">' . $this->h(dbxContactTicket::statusLabel($status)) . '</span>';
         $row['subject_view'] = $this->excerpt($row['subject'] ?? '', 90);
         $row['action'] = $this->tpl()->get_tpl('dbxContact|contact-ticket-row-action', array(
            'rid' => (int) ($row['id'] ?? 0),
         ));
         $out[] = $row;
      }
      return $out;
   }
 
   public function contactListReportRowActionData($report, $data): array {
      if (!is_array($data) || (string) ($data['type'] ?? '') !== 'delete') {
         return $data;
      }
 
      $rid = (int) ($data['record']['id'] ?? $data['data']['rid'] ?? 0);
      $data['data']['action'] = '?dbx_modul=dbxContact&dbx_run1=my&dbx_run2=delete&rid=' . $rid;
      $data['data']['tooltip'] = 'Anfrage entfernen';
 
      return $data;
   }
 
   private function listTickets(int $uid): string {
      $db = $this->db();
      $report = dbx()->get_system_obj('dbxReport');
      $where = 'uid = ' . $uid . ' AND user_hidden = 0';
 
      $report->init('contact-list', 'dbxContact|contact-list');
      $report->add_rep('bar_title', 'Meine Anfragen');
      $report->add_rep('bar_icon', 'bi-life-preserver');
      $report->add_rep('bar_subtitle', 'Status, Antworten und Verlauf Ihrer Tickets');
      $report->add_rep('bar_actions',
         '<a class="btn btn-primary btn-sm" href="?dbx_modul=dbxContact&dbx_run1=form"><i class="bi bi-plus-circle"></i> Neue Anfrage</a>'
      );
      $report->_dd = dbxContactTicket::DD_TICKET;
      $report->_action = '?dbx_modul=dbxContact&dbx_run1=my';
      $report->_pages = true;
      $report->_create_row_select = false;
      $report->_create_row_edit = false;
      $report->_create_row_delete = true;
      $report->_table_buttons = 'left';
      $report->_msg_confirm_delete = 'Anfrage entfernen?';
      $report->set_callback_owner($this);
      $report->set_callback('row_action_data', 'contactListReportRowActionData');
      $report->set_tabel_tpl('tpl_row_delete', 'modul|contact-ticket-row-delete');
      $report->_rflds = array(
         'id' => 'Ticket',
         'last_activity_date' => 'Letzte Aktivitaet',
         'status_view' => 'Status',
         'subject_view' => 'Betreff',
         'action' => '&nbsp;',
      );
      $report->_rpt_format = array(
         'last_activity_date' => 'php-datetime-usr',
         'status_view' => 'html',
         'subject_view' => 'html',
         'action' => 'html',
      );
      $report->_rrows = 30;
      $report->_rpos = 0;
      $report->_count_all = $db->count(dbxContactTicket::DD_TICKET, $where);
      $report->_rcount = $report->_count_all;
      $rows = $db->select(
         dbxContactTicket::DD_TICKET,
         $where,
         array('id', 'last_activity_date', 'create_date', 'status', 'subject'),
         'last_activity_date,id',
         'DESC',
         '',
         30,
         0,
         0
      );
      $report->_rdata = $this->decorateRows(is_array($rows) ? $rows : array());
 
      return $report->run();
   }
 
   private function timeline(array $ticket): string {
      $db = $this->db();
      dbxContactTicket::ensureInitialMessage($db, $ticket);
      $html = '';
 
      foreach (dbxContactTicket::messages($db, (int) $ticket['id'], false) as $message) {
         $authorType = (string) ($message['author_type'] ?? 'system');
         $statusTo = trim((string) ($message['status_to'] ?? ''));
         $html .= $this->tpl()->get_tpl('dbxContact|contact-ticket-message', array(
            'message_class' => $authorType === 'admin' ? 'border-primary bg-primary-subtle' : 'bg-body-tertiary',
            'message_icon' => $authorType === 'admin' ? 'bi-headset' : ($authorType === 'requester' ? 'bi-person' : 'bi-gear'),
            'author_label' => $authorType === 'admin' ? 'Support' : ($authorType === 'requester' ? 'Sie' : 'System'),
            'create_date' => $this->h($message['create_date'] ?? ''),
            'body' => nl2br($this->h($message['body'] ?? '')),
            'status_badge' => $statusTo !== ''
               ? '<span class="badge ' . $this->statusClass($statusTo) . '">Status: ' . $this->h(dbxContactTicket::statusLabel($statusTo)) . '</span>'
               : '',
         ));
      }
 
      return $html !== '' ? $html : '<div class="text-muted">Noch kein Verlauf vorhanden.</div>';
   }
 
   private function messageForm(array $ticket): string {
      $rid = (int) $ticket['id'];
      if ((string) ($ticket['status'] ?? '') === 'closed') {
         return '<div class="alert alert-secondary mb-0">Dieses Ticket ist geschlossen. Fuer ein neues Anliegen legen Sie bitte eine neue Anfrage an.</div>';
      }
 
      $form = dbx()->get_system_obj('dbxForm');
      $form->init('contact-user-message', 'contact-user-message-form');
      $form->_dd = dbxContactTicket::DD_MESSAGE;
      $form->_fd = 'dbxContact|contact-user-message';
      $form->_action = '?dbx_modul=dbxContact&dbx_run1=my&dbx_run2=ticket&rid=' . $rid;
      $form->_data = array('body' => '');
      $form->add_module_bar('Nachricht hinzufuegen', 'bi-chat-dots', 'Ihre Nachricht wird dem Support angezeigt');
      $form->add_rep('bar_title_pre', '');
      $form->add_rep('bar_title_heading_attrs', '');
      $form->add_rep('bar_middle', '');
      $form->add_rep('bar_actions', '');
      $form->add_rep('bar_extra', '');
      $form->add_rep('rid', $rid);
      $form->_msg_info = 'Ergaenzen Sie Informationen oder beantworten Sie eine Rueckfrage des Supports.';
      $form->add_fld('body');
 
      if ($form->submit() && !$form->errors()) {
         $body = trim((string) $form->get_post_data('body', '', '*'));
         $oldStatus = dbxContactTicket::normalizeStatus((string) ($ticket['status'] ?? 'open'));
         $messageId = dbxContactTicket::addMessage($this->db(), $rid, array(
            'author_uid' => (int) dbx()->user(),
            'author_type' => 'requester',
            'message_type' => 'message',
            'visibility' => 'public',
            'body' => $body,
            'status_from' => $oldStatus,
            'status_to' => 'open',
         ));
         if ($messageId > 0) {
            dbxContactTicket::touch($this->db(), $rid, array('status' => 'open', 'closed_date' => ''));
            $form->_msg_success = 'Ihre Nachricht wurde dem Ticket hinzugefuegt.';
            $form->_data['body'] = '';
         } else {
            $form->_msg_error = 'Die Nachricht konnte nicht gespeichert werden.';
         }
      }
 
      return $form->run();
   }
 
   private function ticket(int $uid): string {
      $rid = (int) dbx()->get_modul_var('rid', 0, 'int');
      $ticket = $this->ticketForUser($rid, $uid);
      if (!$ticket) {
         return $this->tpl()->get_tpl('dbx|alert-warning', array('msg' => 'Anfrage nicht gefunden.'));
      }
 
      $messageForm = $this->messageForm($ticket);
      $ticket = $this->ticketForUser($rid, $uid);
      $status = dbxContactTicket::normalizeStatus((string) ($ticket['status'] ?? 'open'));
 
      return $this->tpl()->get_tpl('dbxContact|contact-ticket-detail', array(
         'bar_class' => 'dbx-module-bar',
         'bar_title_class' => 'dbx-module-bar-titleblock',
         'bar_actions_class' => 'dbx-module-bar-actions',
         'bar_title_pre' => '',
         'bar_title_heading_attrs' => '',
         'bar_icon' => 'bi-life-preserver',
         'bar_title' => 'Ticket #' . $rid,
         'bar_subtitle' => 'Kontaktanfrage und Verlauf',
         'bar_middle' => '',
         'bar_actions' => '<a class="btn btn-outline-secondary btn-sm" href="?dbx_modul=dbxContact&amp;dbx_run1=my"><i class="bi bi-arrow-left"></i> Meine Anfragen</a>',
         'bar_extra' => '',
         'rid' => $rid,
         'subject' => $this->h($ticket['subject'] ?? ''),
         'status_label' => $this->h(dbxContactTicket::statusLabel($status)),
         'status_class' => $this->statusClass($status),
         'create_date' => $this->h($ticket['create_date'] ?? ''),
         'timeline' => $this->timeline($ticket),
         'message_form' => $messageForm,
      ));
   }
 
   private function deleteTicket(int $uid): string {
      $rid = (int) dbx()->get_modul_var('rid', 0, 'int');
      $ticket = $this->ticketForUser($rid, $uid);
      if (!$ticket) {
         return $this->tpl()->get_tpl('dbx|alert-warning', array('msg' => 'Anfrage nicht gefunden.'));
      }
 
      $form = dbx()->get_system_obj('dbxForm');
      $form->init('contact-user-delete', 'contact-user-delete-form');
      $form->_fd = 'dbxContact|contact-user-delete';
      $form->_action = '?dbx_modul=dbxContact&dbx_run1=my&dbx_run2=delete&rid=' . $rid;
      $form->_data = array('confirm_delete' => 0);
      $form->add_module_bar('Anfrage ausblenden', 'bi-trash');
      $form->add_rep('bar_title_pre', '');
      $form->add_rep('bar_title_heading_attrs', '');
      $form->add_rep('bar_middle', '');
      $form->add_rep('bar_actions', '');
      $form->add_rep('bar_extra', '');
      $form->add_rep('rid', $rid);
      $form->_msg_info = '';
      $form->add_fld('confirm_delete');
 
      if ($form->submit() && !$form->errors()) {
         $ok = $this->db()->update(dbxContactTicket::DD_TICKET, array(
            'user_hidden' => 1,
            'user_hidden_date' => date('Y-m-d H:i:s'),
         ), 'id = ' . $rid . ' AND uid = ' . $uid, 0, 1, 1, 1);
         if ($ok === 1) {
            return $this->tpl()->get_tpl('dbx|alert-success', array(
               'msg' => 'Die Anfrage wurde aus Ihrer Ansicht entfernt. Der Supportverlauf bleibt erhalten.',
            )) . '<div class="p-3"><a class="btn btn-primary" href="?dbx_modul=dbxContact&dbx_run1=my">Zu meinen Anfragen</a></div>';
         }
         $form->_msg_error = 'Die Anfrage konnte nicht ausgeblendet werden.';
      }
 
      return $form->run();
   }
 
   public function run() {
      $uid = (int) dbx()->user();
      if ($uid <= 0) {
         return $this->denied();
      }
 
      $run2 = dbx()->get_modul_var('dbx_run2', 'list', 'parameter');
      if ($run2 === 'ticket') {
         return $this->ticket($uid);
      }
      if ($run2 === 'delete') {
         return $this->deleteTicket($uid);
      }
      return $this->listTickets($uid);
   }
}