termstatus.admin.inc in Taxonomy Term Status 7

Administrative interface for the taxonomy term status module.

File

termstatus.admin.inc

<?php

/**
 * @file
 * Administrative interface for the taxonomy term status module.
 */

/**
 * Term status settings form.
 */
function termstatus_settings($form, &$form_state) {
  $count = _termstatus_count_nullstatus();
  $enabled = variable_get('termstatus_enable', FALSE);
  if ($count) {
    $form['message'] = array(
      '#markup' => t('There are %count taxonomy terms which do not have any status setting. You need to rebuild the taxonomy term status records.', array(
        '%count' => $count,
      )),
    );
  }
  $form['termstatus_enable'] = array(
    '#type' => 'checkbox',
    '#title' => t('Enable term status'),
    '#description' => t('If enabled, unpublished taxonomy terms are hidden'),
    '#default_value' => $enabled,
    '#disabled' => !$enabled && $count > 0,
  );
  $form['actions']['rebuild'] = array(
    '#type' => 'submit',
    '#value' => t('Rebuild missing status records'),
    '#disabled' => $count == 0,
    '#submit' => array(
      'termstatus_rebuild_submit',
    ),
  );
  return system_settings_form($form);
}

/**
 * Submit callback.
 */
function termstatus_rebuild_submit($form, &$form_state) {
  _termstatus_rebuild();
  drupal_set_message(t('Term status rebuild complete.'));
}

/**
 * Return the number of taxonomy terms which do not have any status record.
 */
function _termstatus_count_nullstatus() {
  $count = db_query('SELECT COUNT(*) FROM {taxonomy_term_data} AS td LEFT JOIN {termstatus} AS ts ON td.tid = ts.tid WHERE ts.status IS NULL')
    ->fetchField();
  return $count;
}

/**
 * Create status records for every taxonomy term which does not have one yet.
 *
 * FIXME: Do we need to batch here?
 */
function _termstatus_rebuild() {
  $query = db_select('taxonomy_term_data', 'td');
  $query
    ->leftjoin('termstatus', 'ts', 'td.tid = ts.tid');
  $query
    ->fields('td', array(
    'tid',
  ));
  $query
    ->addExpression('1', 'status');
  $query
    ->condition('ts.status', NULL, 'IS NULL');
  db_insert('termstatus')
    ->from($query)
    ->execute();
}

Functions

Name	Description
termstatus_rebuild_submit	Submit callback.
termstatus_settings	Term status settings form.
_termstatus_count_nullstatus	Return the number of taxonomy terms which do not have any status record.
_termstatus_rebuild	Create status records for every taxonomy term which does not have one yet.