public function DbMaintenanceAdminSettings::buildForm in DB Maintenance 8

Same name and namespace in other branches

1. 8.2 src/Form/DbMaintenanceAdminSettings.php \Drupal\db_maintenance\Form\DbMaintenanceAdminSettings::buildForm()
2. 2.0.x src/Form/DbMaintenanceAdminSettings.php \Drupal\db_maintenance\Form\DbMaintenanceAdminSettings::buildForm()

Form constructor.

Parameters

array $form: An associative array containing the structure of the form.

\Drupal\Core\Form\FormStateInterface $form_state: The current state of the form.

Return value

array The form structure.

Overrides ConfigFormBase::buildForm

File

src/Form/DbMaintenanceAdminSettings.php, line 57

Contains \Drupal\db_maintenance\Form\DbMaintenanceAdminSettings.

Class

DbMaintenanceAdminSettings

Namespace

Drupal\db_maintenance\Form

Code

public function buildForm(array $form, FormStateInterface $form_state) {
  $dbs = DbHandler::getDatabases();

  // drupal_add_css(drupal_get_path('module', 'db_maintenance') . '/db_maintenance.css');
  //    $form = [];
  $form['write_log'] = [
    '#type' => 'checkbox',
    '#title' => 'Log OPTIMIZE queries',
    //'#default_value' => \Drupal::config('db_maintenance.settings')->get('write_log'),
    '#default_value' => ConfigHandler::getWriteLog(),
    '#description' => t('If enabled, a watchdog entry will be made each time tables are optimized, containing information which tables were involved.'),
  ];
  $options = [
    0 => t('Run during every cron'),
    3600 => t('Hourly'),
    7200 => t('Bi-Hourly'),
    86400 => t('Daily'),
    172800 => t('Bi-Daily'),
    604800 => t('Weekly'),
    1209600 => t('Bi-Weekly'),
    2592000 => t('Monthly'),
    5184000 => t('Bi-Monthly'),
  ];
  $url = Url::fromRoute('db_maintenance.optimize_tables_page');
  $token = \Drupal::csrfToken()
    ->get($url
    ->getInternalPath());
  $url
    ->setOptions([
    'absolute' => TRUE,
    'query' => [
      'token' => $token,
    ],
  ]);
  $internal_link = Link::fromTextAndUrl(t('Optimize now.'), $url)
    ->toString();
  $form['cron_frequency'] = [
    '#type' => 'select',
    '#title' => t('Optimize tables'),
    '#options' => $options,
    '#default_value' => ConfigHandler::getCronFrequency(),
    '#description' => t('Select how often database tables should be optimized.') . ' ' . $internal_link,
  ];

  // Set the databases array if not already set in $db_url.
  $options = [];

  // Visibility.
  $states1 = array(
    'visible' => array(
      ':input[name="use_time_interval"]' => array(
        'checked' => TRUE,
      ),
    ),
  );
  $form['use_time_interval'] = array(
    '#type' => 'checkbox',
    '#title' => t('Use time interval'),
    '#default_value' => ConfigHandler::getUseTimeInterval(),
    '#description' => t('Start optimization only within predefined time interval.'),
  );
  $form['time_interval_start'] = array(
    '#type' => 'textfield',
    '#maxlength' => 25,
    '#title' => t('Time interval start'),
    '#default_value' => ConfigHandler::getTimeIntervalStart(),
    '#description' => t('Time interval start in 24 hour format H:i (HH:MM) like 23:30 or 01:00.'),
    '#states' => $states1,
  );
  $form['time_interval_end'] = array(
    '#type' => 'textfield',
    '#maxlength' => 25,
    '#title' => t('Time interval end'),
    '#default_value' => ConfigHandler::getTimeIntervalEnd(),
    '#description' => t('Time interval end in 24 hour format H:i (HH:MM) like 23:30 or 01:00.'),
    '#states' => $states1,
  );

  // Visibility.
  $states = [
    'visible' => [
      ':input[name="all_tables"]' => [
        'checked' => FALSE,
      ],
    ],
  ];
  $form['all_tables'] = [
    '#type' => 'checkbox',
    '#title' => t('Optimize all tables'),
    '#default_value' => ConfigHandler::getProcessAllTables(),
    '#description' => t('Automatically optimize all tables in the database(s) without having to select them first.'),
  ];

  // Loop through each database and list the possible tables to optimize.
  foreach ($dbs as $db => $connection) {
    $options = DbHandler::listTables($db);
    $form['table_list_' . $connection['default']['database']] = [
      '#type' => 'select',
      '#title' => t('Tables in the @db database', [
        '@db' => $connection['default']['database'] == 'default' ? 'Drupal' : $connection['default']['database'],
      ]),
      '#options' => $options,
      '#default_value' => ConfigHandler::getTableList($connection['default']['database'], ''),
      '#description' => t('Selected tables will be optimized during cron runs.'),
      '#multiple' => TRUE,
      '#attributes' => [
        'size' => 17,
      ],
      '#states' => $states,
    ];
  }
  return parent::buildForm($form, $form_state);
}