user_list.class.php

Go to the documentation of this file.

<?php
namespace dbx\dbxUser_admin;
dbx()->use_system_class('dbxReport');
 
class dbxReport_User extends \dbxReport {
  public function run_body($content) {
    $this->_record = is_array($this->_record) ? $this->_record : array();
    return $content;
  }
}
 
Class user_list {
 
   private $dd = 'dbxUser';
 
   private function base_url($run2, $params = array()) {
      $url = '?dbx_modul=dbxUser_admin&dbx_run1=user&dbx_run2=' . rawurlencode((string) $run2);
      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 avatar_file($file) {
      $file = trim((string) $file);
      if ($file === '' || !preg_match('/^[A-Za-z0-9_.-]+\.(png|jpg|jpeg|webp|gif)$/i', $file)) {
         return 'avatar-0.png';
      }
 
      $path = dbx_get_base_dir() . 'dbx/modules/dbxUser/img/avatar/' . $file;
      return is_file($path) ? $file : 'avatar-0.png';
   }
 
   private function status_label($status) {
      $status = (string) $status;
      if ($status === '1') return 'Aktiv';
      if ($status === '2') return 'Gesperrt';
      if ($status === '3') return 'Archiv';
      return 'Neu';
   }
 
   private function user_row($row) {
      $row = is_array($row) ? $row : array();
      $avatar = $this->avatar_file($row['avatar'] ?? '');
      $name = trim((string)($row['name'] ?? '') . ' ' . (string)($row['name2'] ?? ''));
 
      $row['avatar'] = $avatar;
      $row['avatar_img'] = dbx()->get_base_url() . 'dbx/modules/dbxUser/img/avatar/' . $avatar;
      $row['display_name'] = $name !== '' ? $name : (string)($row['uname'] ?? '');
      $row['status_label'] = $this->status_label($row['status'] ?? 0);
      $row['profile_link'] = $this->base_url('edit_profil', array('rid' => (int)($row['id'] ?? 0)));
 
      return $row;
   }
 
   private function allowed_grid_fields() {
      return array(
         'uname', 'name', 'name2', 'email', 'roles', 'status', 'language',
         'telefon', 'handy', 'strasse', 'plz', 'ort', 'land', 'BSNR', 'LANR',
         'emailbill', 'is_confirm', 'login_pid', 'logout_pid', 'design', 'color'
      );
   }
 
   private function normalize_grid_row($row, $is_new = false) {
      $allowed = array_flip($this->allowed_grid_fields());
      $out = array();
 
      foreach ((array) $row as $key => $value) {
         if (!isset($allowed[$key])) {
            continue;
         }
         if (is_array($value)) {
            $value = implode(',', $value);
         }
         $out[$key] = trim((string) $value);
      }
 
      foreach (array('status', 'is_confirm') as $intField) {
         if (isset($out[$intField])) {
            $out[$intField] = (int) $out[$intField];
         }
      }
 
      if ($is_new) {
         if (empty($out['uname'])) {
            $out['uname'] = 'neuer.benutzer.' . date('YmdHis');
         }
         if (empty($out['status'])) {
            $out['status'] = 1;
         }
         if (empty($out['language'])) {
            $out['language'] = 'de';
         }
         if (empty($out['name'])) {
            $out['name'] = 'Neuer';
         }
         if (empty($out['name2'])) {
            $out['name2'] = 'Benutzer';
         }
         $out['pass'] = md5(bin2hex(random_bytes(8)));
      }
 
      return $out;
   }
 
   private function grid_cols() {
      return implode(',', array(
         'id[ID]:number:p:width=72;hozAlign=center;headerHozAlign=center',
         'avatar_img[Avatar]:image:p:width=78;imgWidth=38px;imgHeight=38px',
         'uname[Login]:text::width=160',
         'display_name[Name]:text:p:width=210',
         'name[Vorname]:text::width=150',
         'name2[Nachname]:text::width=150',
         'email[E-Mail]:text::width=230',
         'roles[Gruppen]:text::width=180',
         'status[Status]:text::editor=list;values=0=Neu~1=Aktiv~2=Gesperrt~3=Archiv;width=110',
         'language[Sprache]:text::editor=list;values=de=Deutsch~en=English;width=105',
         'telefon[Telefon]:text::width=140',
         'handy[Mobil]:text::width=140',
         'plz[PLZ]:text::width=90',
         'ort[Ort]:text::width=150',
         'lastvisit[Letzter Login]:text:p:width=170',
         'is_confirm[Best.]:text::editor=list;values=0=Nein~1=Ja;width=90'
      ));
   }
 
   private function grid_read() {
      $oDB = dbx()->get_system_obj('dbxDB');
      $search = dbx()->get_request_var('dbx_search', '', 'sqlsearch|max=128');
      $where = $oDB->build_search_where($this->dd, $search, array('uname', 'name', 'name2', 'email', 'roles', 'ort'), array('id'), 'contains');
      $sort = dbx()->get_request_var('dbx_sorters', '', '*');
      $rsort = 'id';
      $rdesc = 'ASC';
 
      if ($sort) {
         $sorters = json_decode($sort, true);
         if (is_array($sorters) && isset($sorters[0]['field'])) {
            $field = (string) $sorters[0]['field'];
            if (in_array($field, array('id', 'uname', 'name', 'name2', 'email', 'status', 'lastvisit'), true)) {
               $rsort = $field;
               $rdesc = strtolower((string)($sorters[0]['dir'] ?? 'asc')) === 'desc' ? 'DESC' : 'ASC';
            }
         }
      }
 
      $flds = array('id', 'uname', 'name', 'name2', 'email', 'roles', 'status', 'language', 'telefon', 'handy', 'plz', 'ort', 'lastvisit', 'is_confirm', 'avatar');
      $rows = $oDB->select($this->dd, $where, $flds, $rsort, $rdesc, '', 1000, 0);
      if (!is_array($rows)) {
         $rows = array();
      }
 
      $out = array();
      foreach ($rows as $row) {
         $out[] = $this->user_row($row);
      }
 
      dbx()->json_response(array(
         'ok' => 1,
         'count' => count($out),
         'rows' => $out,
         'server_time' => date('Y-m-d H:i:s')
      ));
   }
 
   private function grid_save() {
      $oDB = dbx()->get_system_obj('dbxDB');
      $payload = $this->request_json();
      $rows = is_array($payload['rows'] ?? null) ? $payload['rows'] : array();
      $saved = array();
 
      foreach ($rows as $row) {
         $id = (int)($row['id'] ?? 0);
         if ($id <= 0) {
            continue;
         }
         $data = $this->normalize_grid_row($row);
         if (!$data) {
            continue;
         }
         $ok = $oDB->update($this->dd, $data, $id);
         if ($ok >= 0) {
            $saved[] = $this->user_row($oDB->select1($this->dd, $id));
         }
      }
 
      dbx()->json_response(array('ok' => 1, 'success' => true, 'rows' => $saved));
   }
 
   private function grid_insert() {
      $oDB = dbx()->get_system_obj('dbxDB');
      $data = $this->normalize_grid_row(array(), true);
      $id = ($oDB->insert($this->dd, $data) === 1) ? $oDB->get_insert_id() : 0;
 
      if ($id > 0) {
         $row = $oDB->select1($this->dd, $id);
         dbx()->json_response(array('ok' => 1, 'success' => true, 'row' => $this->user_row($row)));
      }
 
      dbx()->json_response(array('ok' => 0, 'success' => false, 'msg' => 'Benutzer konnte nicht angelegt werden.'));
   }
 
   private function grid_delete() {
      $payload = $this->request_json();
      $id = (int)($payload['id'] ?? 0);
      if ($id <= 0) {
         dbx()->json_response(array('ok' => 0, 'success' => false, 'msg' => 'ID fehlt.'));
      }
 
      $oDB = dbx()->get_system_obj('dbxDB');
      $ok = $oDB->delete($this->dd, $id);
      dbx()->json_response(array('ok' => $ok ? 1 : 0, 'success' => $ok ? true : false));
   }
 
   public function edit($rid=0) {
      $obj=dbx()->get_include_obj('dbxUser_view');
      $content=$obj->run();
      return $content;
   }
 
   public function list() {
      $oReport = dbx()->get_system_obj('dbxReport');
      $oDB     = dbx()->get_system_obj('dbxDB');
      $all     = $oDB->count($this->dd);
      $active  = $oDB->count($this->dd, 'status = 1');
      $locked  = $oDB->count($this->dd, 'status = 2');
 
      $oReport->init('report-user-grid', 'user-admin-grid');
      $oReport->add_rep('shell_panel_class', 'dbx-grid dbx-user-admin dbx-ajax-root');
      $oReport->add_rep('bar_title', 'Benutzerverwaltung');
      $oReport->add_rep('bar_subtitle', 'Benutzer, Gruppen, Status und Profildaten zentral verwalten');
      $oReport->_mode = 'tabulurator';
      $oReport->_rrows = 620;
      $oReport->_grid_id = 'dbx_user_admin_grid';
      $oReport->_grid_cols = $this->grid_cols();
      $oReport->_grid_layout = 'fitDataStretch';
      $oReport->_grid_read_url   = $this->base_url('user_grid_read');
      $oReport->_grid_save_url   = $this->base_url('user_grid_save');
      $oReport->_grid_insert_url = $this->base_url('user_grid_insert');
      $oReport->_grid_delete_url = $this->base_url('user_grid_delete');
      $oReport->add_grid_stats(array(
         array('label' => 'Gesamt', 'value' => (string)$all),
         array('label' => 'Aktiv', 'value' => (string)$active, 'tone' => 'ok'),
         array('label' => 'Gesperrt', 'value' => (string)$locked, 'tone' => 'lock'),
      ), 'Benutzer Kennzahlen');
      $oReport->add_obj('new_user_url', 'obj-value', $this->base_url('new_user'));
      $oReport->add_obj('groups_url', 'obj-value', $this->base_url('list_groups'));
      $oReport->add_obj('bar_actions', 'obj-value',
         '<a class="btn btn-primary btn-sm dbx-win" href="' . dbx()->esc($this->base_url('new_user')) . '" data-url="' . dbx()->esc($this->base_url('new_user')) . '" data-title="Benutzer" title="Neuer Benutzer"><i class="bi bi-person-plus"></i></a>'
         . '<a class="btn btn-outline-secondary btn-sm" href="' . dbx()->esc($this->base_url('list_groups')) . '" title="Gruppen verwalten"><i class="bi bi-people"></i></a>'
      );
 
      return $oReport->run();
   }
 
   public function run() {
      $work = dbx()->get_modul_var('dbx_run2', 'list_user', 'parameter');
      $content = '';
 
      switch ($work) {
         case 'user_grid_read':
            $this->grid_read();
            break;
         case 'user_grid_save':
            $this->grid_save();
            break;
         case 'user_grid_insert':
            $this->grid_insert();
            break;
         case 'user_grid_delete':
            $this->grid_delete();
            break;
         default:
            $content=$this->list();
            break;
      }
 
      return $content;
   }
}
 
?>