You are here

class AddViewsCustomTable in Views Custom Table 8

Same name and namespace in other branches
  1. 9.0.x src/Form/AddViewsCustomTable.php \Drupal\view_custom_table\Form\AddViewsCustomTable

Add views custom table form.

Hierarchy

Expanded class hierarchy of AddViewsCustomTable

1 string reference to 'AddViewsCustomTable'
view_custom_table.routing.yml in ./view_custom_table.routing.yml
view_custom_table.routing.yml

File

src/Form/AddViewsCustomTable.php, line 20

Namespace

Drupal\view_custom_table\Form
View source
class AddViewsCustomTable extends FormBase {

  /**
   * Step of the form.
   *
   * @var int
   */
  protected $step;

  /**
   * Previous step form data.
   *
   * @var array
   */
  protected $PreviousStepData;

  /**
   * Entity Manager for calss.
   *
   * @var \Drupal\Core\Entity\EntityTypeManager
   */
  protected $entityManager;

  /**
   * Drupal\Core\Session\AccountProxy definition.
   *
   * @var \Drupal\Core\Session\AccountProxy
   */
  protected $account;

  /**
   * Drupal\Core\Config\ImmutableConfig definition.
   *
   * @var \Drupal\Core\Config\ImmutableConfig
   */
  protected $config;

  /**
   * Drupal\Core\Config\Config definition.
   *
   * @var \Drupal\Core\Config\Config
   */
  protected $configEditable;

  /**
   * Class constructor.
   */
  public function __construct(AccountProxy $account, EntityTypeManager $entityManager, ImmutableConfig $config, Config $configEditable) {
    $this->step = 1;
    $this->PreviousStepData = [];
    $this->account = $account;
    $this->entityManager = $entityManager;
    $this->config = $config;
    $this->configEditable = $configEditable;
  }

  /**
   * {@inheritdoc}
   */
  public static function create(ContainerInterface $container) {
    return new static($container
      ->get('current_user'), $container
      ->get('entity_type.manager'), $container
      ->get('config.factory')
      ->get('view_custom_table.tables'), $container
      ->get('config.factory')
      ->getEditable('view_custom_table.tables'));
  }

  /**
   * {@inheritdoc}
   */
  public function getFormId() {
    return 'view_custom_table_add_table_form';
  }

  /**
   * {@inheritdoc}
   */
  public function buildForm(array $form, FormStateInterface $form_state) {
    if ($this->step == 1) {
      $all_database_connections = Database::getAllConnectionInfo();
      foreach ($all_database_connections as $connection_name => $connection) {
        $displyName = $connection['default']['database'];
        $databaseOptions[$connection_name] = $displyName;
      }
      $form['table_database'] = [
        '#type' => 'select',
        '#options' => $databaseOptions,
        '#title' => $this
          ->t('Database'),
      ];
      $form['table_name'] = [
        '#type' => 'textfield',
        '#title' => $this
          ->t('Table'),
        '#required' => TRUE,
      ];
      $form['description'] = [
        '#type' => 'textarea',
        '#title' => $this
          ->t('Description'),
        '#rows' => 5,
        '#description' => $this
          ->t('Maximum 255 letters are allowed.'),
      ];
      $form['actions'] = [
        '#type' => 'actions',
      ];
      $form['actions']['next'] = [
        '#type' => 'submit',
        '#value' => $this
          ->t('Next'),
      ];
    }
    elseif ($this->step == 2) {
      $table_name = $this->PreviousStepData['table_name'];
      $databaseName = $this->PreviousStepData['table_database'];
      $form['columns'] = [
        '#type' => 'fieldset',
        '#title' => $this
          ->t('"@table" Int Type Columns', [
          '@table' => $table_name,
        ]),
        '#tree' => TRUE,
      ];
      $entities['none'] = $this
        ->t('None');
      if ($databaseName == 'default') {
        $all_entities = $this->entityManager
          ->getDefinitions();
        foreach ($all_entities as $entity_name => $entity) {
          if ($entity
            ->getBaseTable()) {
            $entities[$entity_name] = $entity
              ->getLabel()
              ->render();
          }
        }
      }
      $all_custom_tables = $this->config
        ->getRawData();
      if (!empty($all_custom_tables)) {
        foreach ($all_custom_tables as $custom_table) {
          if ($custom_table['table_database'] == $databaseName && $custom_table['table_name'] != $table_name) {
            $entities[$custom_table['table_name']] = $custom_table['table_name'];
          }
        }
      }
      $int_types = [
        'tinyint',
        'smallint',
        'mediumint',
        'int',
        'bigint',
      ];
      $text_query = new FormattableMarkup('DESCRIBE @table_name', [
        '@table_name' => $table_name,
      ]);
      $connection = Database::getConnection('default', $databaseName);
      $query = $connection
        ->query($text_query);
      foreach ($query as $row) {
        $row_type = explode('(', $row->Type);
        if (in_array($row_type[0], $int_types)) {
          $form['columns']['column_' . $row->Field] = [
            '#type' => 'fieldset',
            '#title' => $this
              ->t('Relation of "@field_name" with', [
              '@field_name' => ucfirst($row->Field),
            ]),
            '#tree' => TRUE,
            '#attributes' => [
              'class' => [
                'container-inline',
              ],
            ],
          ];
          $form['columns']['column_' . $row->Field]['entity'] = [
            '#type' => 'select',
            '#title' => $this
              ->t('Entity'),
            '#options' => $entities,
          ];
          $form['columns']['column_' . $row->Field]['field'] = [
            '#type' => 'hidden',
            '#value' => $row->Field,
          ];
        }
      }
      $form['actions']['submit'] = [
        '#type' => 'submit',
        '#value' => $this
          ->t('Save'),
      ];
    }
    $form['actions']['cancel'] = [
      '#type' => 'link',
      '#title' => $this
        ->t('Cancel'),
      '#url' => $this
        ->buildCancelLinkUrl(),
    ];
    return $form;
  }

  /**
   * {@inheritdoc}
   */
  public function validateForm(array &$form, FormStateInterface $form_state) {
    if ($this->step == 1) {
      $databaseName = $form_state
        ->getValue('table_database');
      $table_name = $form_state
        ->getValue('table_name');
      $description = $form_state
        ->getValue('description');
      $connection = Database::getConnection('default', $databaseName);
      if (!$connection
        ->schema()
        ->tableExists($table_name)) {
        $form_state
          ->setErrorByName('table_name', $this
          ->t('@table not found in database @database_name, please check table name, and database again.', [
          '@table' => $table_name,
          '@database_name' => $databaseName,
        ]));
      }
      $config = $this->config
        ->getRawData();
      if (isset($config[$table_name]) && $config[$table_name]['table_database'] == $databaseName) {
        $form_state
          ->setErrorByName('table_name', $this
          ->t("@table is already available for views. If you can't find it, please clear cache and try again.", [
          '@table' => $table_name,
        ]));
      }
      if (strlen($description) > 254) {
        $form_state
          ->setErrorByName('description', $this
          ->t("Description can not be more then 255 letters. Please update it and try again.", [
          '@table' => $table_name,
        ]));
      }
    }
  }

  /**
   * {@inheritdoc}
   */
  public function submitForm(array &$form, FormStateInterface $form_state) {
    $opeation = $form_state
      ->getValue('op')
      ->render();
    if ($opeation == $this
      ->t('Next')) {
      $this->PreviousStepData = $form_state
        ->cleanValues()
        ->getValues();
      $form_state
        ->setRebuild();
      $this->step++;
    }
    if ($opeation == $this
      ->t('Save')) {
      $user = $this->account;
      $table_name = $this->PreviousStepData['table_name'];
      $table_database = $this->PreviousStepData['table_database'];
      $description = $this->PreviousStepData['description'];
      $relations = $form_state
        ->getValue('columns');
      $column_relations = [];
      foreach ($relations as $relation) {
        if ($relation['entity'] != 'none') {
          $column_relations[$relation['field']] = $relation['entity'];
        }
      }
      $serialize_relations = serialize($column_relations);
      $this->configEditable
        ->set($table_name . '.table_name', $table_name)
        ->set($table_name . '.table_database', $table_database)
        ->set($table_name . '.description', $description)
        ->set($table_name . '.column_relations', $serialize_relations)
        ->set($table_name . '.created_by', $user
        ->id());
      $result = $this->configEditable
        ->save();
      if ($result) {
        drupal_set_message($this
          ->t('@table is added to views. Please clear cache to see changes.', [
          '@table' => $table_name,
        ]));
      }
      else {
        drupal_set_message($this
          ->t('Could not add table to views, please check log messages for error.'), 'error');
      }
    }
    $form_state
      ->setRedirect('view_custom_table.customtable');
  }

  /**
   * Builds the cancel link url for the form.
   *
   * @return Drupal\Core\Url
   *   Cancel url
   */
  private function buildCancelLinkUrl() {
    $query = $this
      ->getRequest()->query;
    if ($query
      ->has('destination')) {
      $options = UrlHelper::parse($query
        ->get('destination'));
      $url = Url::fromUri('internal:/' . $options['path'], $options);
    }
    else {
      $url = Url::fromRoute('view_custom_table.customtable');
    }
    return $url;
  }

}

Members

Namesort descending Modifiers Type Description Overrides
AddViewsCustomTable::$account protected property Drupal\Core\Session\AccountProxy definition.
AddViewsCustomTable::$config protected property Drupal\Core\Config\ImmutableConfig definition.
AddViewsCustomTable::$configEditable protected property Drupal\Core\Config\Config definition.
AddViewsCustomTable::$entityManager protected property Entity Manager for calss.
AddViewsCustomTable::$PreviousStepData protected property Previous step form data.
AddViewsCustomTable::$step protected property Step of the form.
AddViewsCustomTable::buildCancelLinkUrl private function Builds the cancel link url for the form.
AddViewsCustomTable::buildForm public function Form constructor. Overrides FormInterface::buildForm
AddViewsCustomTable::create public static function Instantiates a new instance of this class. Overrides FormBase::create
AddViewsCustomTable::getFormId public function Returns a unique string identifying the form. Overrides FormInterface::getFormId
AddViewsCustomTable::submitForm public function Form submission handler. Overrides FormInterface::submitForm
AddViewsCustomTable::validateForm public function Form validation handler. Overrides FormBase::validateForm
AddViewsCustomTable::__construct public function Class constructor.
DependencySerializationTrait::$_entityStorages protected property An array of entity type IDs keyed by the property name of their storages.
DependencySerializationTrait::$_serviceIds protected property An array of service IDs keyed by property name used for serialization.
DependencySerializationTrait::__sleep public function 1
DependencySerializationTrait::__wakeup public function 2
FormBase::$configFactory protected property The config factory. 1
FormBase::$requestStack protected property The request stack. 1
FormBase::$routeMatch protected property The route match.
FormBase::config protected function Retrieves a configuration object.
FormBase::configFactory protected function Gets the config factory for this form. 1
FormBase::container private function Returns the service container.
FormBase::currentUser protected function Gets the current user.
FormBase::getRequest protected function Gets the request object.
FormBase::getRouteMatch protected function Gets the route match.
FormBase::logger protected function Gets the logger for a specific channel.
FormBase::redirect protected function Returns a redirect response object for the specified route. Overrides UrlGeneratorTrait::redirect
FormBase::resetConfigFactory public function Resets the configuration factory.
FormBase::setConfigFactory public function Sets the config factory for this form.
FormBase::setRequestStack public function Sets the request stack object to use.
LinkGeneratorTrait::$linkGenerator protected property The link generator. 1
LinkGeneratorTrait::getLinkGenerator Deprecated protected function Returns the link generator.
LinkGeneratorTrait::l Deprecated protected function Renders a link to a route given a route name and its parameters.
LinkGeneratorTrait::setLinkGenerator Deprecated public function Sets the link generator service.
LoggerChannelTrait::$loggerFactory protected property The logger channel factory service.
LoggerChannelTrait::getLogger protected function Gets the logger for a specific channel.
LoggerChannelTrait::setLoggerFactory public function Injects the logger channel factory.
MessengerTrait::$messenger protected property The messenger. 29
MessengerTrait::messenger public function Gets the messenger. 29
MessengerTrait::setMessenger public function Sets the messenger.
RedirectDestinationTrait::$redirectDestination protected property The redirect destination service. 1
RedirectDestinationTrait::getDestinationArray protected function Prepares a 'destination' URL query parameter for use with \Drupal\Core\Url.
RedirectDestinationTrait::getRedirectDestination protected function Returns the redirect destination service.
RedirectDestinationTrait::setRedirectDestination public function Sets the redirect destination service.
StringTranslationTrait::$stringTranslation protected property The string translation service. 1
StringTranslationTrait::formatPlural protected function Formats a string containing a count of items.
StringTranslationTrait::getNumberOfPlurals protected function Returns the number of plurals supported by a given language.
StringTranslationTrait::getStringTranslation protected function Gets the string translation service.
StringTranslationTrait::setStringTranslation public function Sets the string translation service to use. 2
StringTranslationTrait::t protected function Translates a string to the current language or to a given language.
UrlGeneratorTrait::$urlGenerator protected property The url generator.
UrlGeneratorTrait::getUrlGenerator Deprecated protected function Returns the URL generator service.
UrlGeneratorTrait::setUrlGenerator Deprecated public function Sets the URL generator service.
UrlGeneratorTrait::url Deprecated protected function Generates a URL or path for a specific route based on the given parameters.