function db_maintenance_admin_settings in DB Maintenance 8.2

Same name and namespace in other branches

1. 5.2 db_maintenance.module \db_maintenance_admin_settings()
2. 5 db_maintenance.module \db_maintenance_admin_settings()
3. 6.2 db_maintenance.module \db_maintenance_admin_settings()
4. 6 db_maintenance.module \db_maintenance_admin_settings()
5. 7.2 db_maintenance.admin.inc \db_maintenance_admin_settings()
6. 7 db_maintenance.admin.inc \db_maintenance_admin_settings()

Administration settings

options: log each optimization multi-select list of tables to optimize

Return value

array

2 string references to 'db_maintenance_admin_settings'

DbMaintenanceAdminSettings::getFormId in src/Form/DbMaintenanceAdminSettings.php

Returns a unique string identifying the form.

db_maintenance_menu in ./db_maintenance.module

Implements hook_menu().

File

./db_maintenance.admin.inc, line 16

db_maintenance admin section.

Code

function db_maintenance_admin_settings() {
  global $databases;

  // @FIXME
  // CSS, JavaScript, and libraries are now attached directly to render arrays
  // using the #attached property. drupal_add_css() is internal and should never be
  // called directly.
  //
  //
  // @see https://www.drupal.org/node/2169605
  // drupal_add_css(drupal_get_path('module', 'db_maintenance') .'/db_maintenance.css');
  $form = array();
  $form['db_maintenance_log'] = array(
    '#type' => 'checkbox',
    '#title' => 'Log OPTIMIZE queries',
    '#default_value' => \Drupal::config('db_maintenance.settings')
      ->get('db_maintenance_log'),
    '#description' => t('If enabled, a watchdog entry will be made each time tables are optimized, containing information which tables were involved.'),
  );
  $options = array(
    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'),
  );

  // @FIXME
  // l() expects a Url object, created from a route name or external URI.
  // $form['db_maintenance_cron_frequency'] = array(
  //     '#type' => 'select',
  //     '#title' => t('Optimize tables'),
  //     '#options' => $options,
  //     '#default_value' => variable_get('db_maintenance_cron_frequency', 86400),
  //     '#description' => t('Select how often database tables should be optimized.') . ' ' . l(t('Optimize now.'), 'db_maintenance/optimize'),
  //   );
  // Set the databases array if not already set in $db_url.
  $options = array();

  // Visibility.
  $states = array(
    'visible' => array(
      ':input[name="db_maintenance_all_tables"]' => array(
        'checked' => FALSE,
      ),
    ),
  );
  $form['db_maintenance_all_tables'] = array(
    '#type' => 'checkbox',
    '#title' => t('Optimize all tables'),
    '#default_value' => \Drupal::config('db_maintenance.settings')
      ->get('db_maintenance_all_tables'),
    '#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 ($databases as $db => $connection) {
    $options = _db_maintenance_list_tables($db);

    // @FIXME
    // // @FIXME
    // // The correct configuration object could not be determined. You'll need to
    // // rewrite this call manually.
    // $form['db_maintenance_table_list_' . $connection['default']['database']] = array(
    //       '#type' => 'select',
    //       '#title' => t('Tables in the !db database', array('!db' => $connection['default']['database'] == 'default' ? 'Drupal' : $connection['default']['database'])),
    //       '#options' => $options,
    //       '#default_value' => variable_get('db_maintenance_table_list_' . $connection['default']['database'], ''),
    //       '#description' => t('Selected tables will be optimized during cron runs.'),
    //       '#multiple' => TRUE,
    //       '#attributes' => array('size' => 17),
    //       '#states' => $states,
    //     );
  }
  return system_settings_form($form);
}