dbxMissing.class.php

Go to the documentation of this file.

<?php
namespace dbx\dbxAdmin;
 
class dbxMissing {
 
   private function action_url($url) {
      $sep = (strpos((string)$url, '?') === false) ? '?' : '&';
      return $url . $sep . 'dbx_token=' . rawurlencode(dbx()->action_token('dbxAdmin.missing'));
   }
 
   private function check_action_token($work, $oReport) {
      if (!$work) return true;
      $token = dbx()->get_modul_var('dbx_token', '', 'varchar|max=128');
      if (dbx()->check_action_token('dbxAdmin.missing', $token)) return true;
      $oReport->_msg_err = 'Aktion abgelehnt: Sicherheits-Token fehlt oder ist ungueltig.';
      dbx()->sys_msg('security', 'dbxAdmin', dbx()->user(), 'invalid admin missing action token', $_SERVER['REQUEST_URI'] ?? '');
      return false;
   }
 
   private function delete_table_action(): string {
      return '<a class="btn btn-sm btn-outline-danger dbxAjax dbxConfirm"'
         . ' href="' . dbx()->esc($this->action_url('?dbx_modul=dbxAdmin&dbx_run1=missing&dbx_run2=list_missing&dbx_do=delete_tab')) . '"'
         . ' title="Missing-Eintraege leeren"'
         . ' data-confirm-title="<i class=\'bi bi-trash3\'></i> Missing-Eintraege leeren"'
         . ' data-confirm="Alle Missing-Eintraege wirklich loeschen?"'
         . ' data-confirm-hint="<small>Die Tabelle dbxMissing wird komplett geleert. Dieser Vorgang kann nicht rueckgaengig gemacht werden.</small>"'
         . ' data-confirm-buttons="yesno"'
         . ' role="button"><i class="bi bi-trash3"></i></a>';
   }
 
   private function report_missing() {
      $content = '';
      $dd      = 'dbxMissing';
 
      $db      = dbx()->get_system_obj('dbxDB');
      $oReport = dbx()->get_system_obj('dbxReport');
      $oReport->init('report-missing');
      $oReport->_dd = $dd;
      $oReport->add_rep('bar_actions', $this->delete_table_action());
 
      $work = dbx()->get_modul_var('dbx_do', '', 'parameter');
      $rid  = dbx()->get_modul_var('rid', 0, 'int');
      $actionAllowed = $this->check_action_token($work, $oReport);
 
      if ($actionAllowed && $work == 'row_delete' && $rid) {
         $ok = $oReport->del_selected($rid);
         $ok = $db->delete($dd, $rid);
 
         if ( $ok) $oReport->_msg_success = 'Zeile geloescht';
         if (!$ok) $oReport->_msg_err     = 'Zeile konnte nicht geloescht werden';
      }
 
      if ($actionAllowed && $work == 'multi_delete') {
         $result = $oReport->delete_multi_selected_records($dd);
         $oReport->apply_multi_delete_result($result);
      }
 
      if ($actionAllowed && $work == 'delete_tab') {
         $ok = $db->delete_tab($dd);
         dbx()->debug("##delete tab dd=($dd) ok=($ok)");
         if ( $ok) $oReport->_msg_success = 'Datenbank-Tabelle geleert';
         if (!$ok) $oReport->_msg_err     = 'Datenbank-Tabelle konnte nicht geleert werden';
      }
 
      $flds['id']          = 'ID';
      $flds['create_date'] = 'Create';
      $flds['update_date'] = 'Update';
      $flds['count']       = 'Count';
      $flds['missing']     = 'Missing';
 
      $rformat['create_date'] = 'php-datetime-usr';
      $rformat['update_date'] = 'php-datetime-usr';
      $oReport->_rpt_format   = $rformat;
 
      $oReport->_action            = '?dbx_modul=dbxAdmin&dbx_run1=missing&dbx_run2=list_missing';
      $oReport->_action            = $this->action_url($oReport->_action);
      $oReport->_pages             = true;
      $oReport->_create_row_select = true;
      $oReport->_create_row_edit   = false;
      $oReport->_create_row_delete = true;
      $oReport->_create_sel_flds   = true;
      $oReport->_but_pagination    = 5;
 
      $oReport->enable_delete_tab($dd);
 
      $oReport->add_action('rows_delete'   , 'action_button_delete'  , '&dbx_do=multi_delete');
 
      $oReport->create_selection_fields('dbxAdmin|rpt-missing-selection');
 
      if ($work != 'delete_tab' && $work != 'multi_delete' && $work != 'row_delete' && $oReport->submit()) {
         if (!$oReport->errors()) {
            $oReport->_msg_success = '';
         } else {
            $oReport->_msg_err = 'Pruefen sie bitte ihre Eingaben';
         }
      }
 
      $rwhere = $oReport->get_fld_val('dbx_rwhere' , ''           , 'sqlsearch|max=64');
      $rrows  = $oReport->get_fld_val('dbx_rrows'  , 15           , 'int');
      $rpos   = $oReport->get_fld_val('dbx_rpos'   , 0            , 'int');
      $rsort  = $oReport->get_fld_val('dbx_rsort'  , 'update_date', 'parameter');
      $rdesc  = $oReport->get_fld_val('dbx_rdesc'  , 'DESC'       , 'parameter');
      $select = $oReport->get_fld_val('dbx_rselect', 0            , 'int');
      $rgroup = '';
 
      if ($rwhere != '') {
         $rwhere = array(
            'search' => array(
               'value' => $rwhere,
               'like'  => array('missing'),
               'mode'  => 'starts_with',
            ),
         );
      }
 
      if ($select) {
         if (is_array($rwhere)) {
            $rwhere = $db->normalize_where($dd, $rwhere);
         }
 
         $rwhere = $oReport->add_rwhere_select($rwhere);
      }
 
      $oReport->_rflds     = $flds;
      $oReport->_rrows     = $rrows;
      $oReport->_rpos      = $rpos;
      $oReport->_count_all = $db->count($dd);
      $oReport->_rcount    = $db->count($dd, $rwhere);
      $oReport->_rdata     = $db->select($dd, $rwhere, $flds, $rsort, $rdesc, $rgroup, $rrows, $rpos);
 
      $content = $oReport->run();
 
      return $content;
   }
 
   public function run() {
      return $this->report_missing();
   }
 
}
?>