Club Drupal

<?php

/**

 * @file

 * Webform module multiple select component.

 */

/**

 * Implements _webform_defaults_component().

 */

function _webform_defaults_select() {

  return array(

    'name' => '',

    'form_key' => NULL,

    'required' => 0,

    'pid' => 0,

    'weight' => 0,

    'value' => '',

    'extra' => array(

      'items' => '',

      'multiple' => NULL,

      'aslist' => NULL,

      'empty_option' => '',

      'optrand' => 0,

      'other_option' => NULL,

      'other_text' => t('Other...'),

      'title_display' => 0,

      'description' => '',

      'description_above' => FALSE,

      'custom_keys' => FALSE,

      'options_source' => '',

      'private' => FALSE,

      'analysis' => TRUE,

    ),

  );

}

/**

 * Implements _webform_theme_component().

 */

function _webform_theme_select() {

  return array(

    'webform_display_select' => array(

      'render element' => 'element',

      'file' => 'components/select.inc',

    ),

  );

}

/**

 * Implements _webform_edit_component().

 */

function _webform_edit_select($component) {

  $form = array(

    '#attached' => array(

      'js' => array(

        drupal_get_path('module', 'webform') . '/js/select-admin.js' => array('preprocess' => FALSE),

        array('data' => array('webform' => array('selectOptionsUrl' => url('webform/ajax/options/' . $component['nid']))), 'type' => 'setting'),

      ),

    ),

  );

  // Default component if nested under a grid.

  if (!isset($component['cid']) && $component['pid'] &&

      ($node = node_load($component['nid'])) && ($parent = $node->webform['components'][$component['pid']]) &&

      $parent['type'] == 'grid') {

    $component['value'] = $parent['value'];

    $component['extra']['items'] = $parent['extra']['options'];

    $component['required'] = $parent['required'];

  }

  $other = array();

  if ($info = _webform_select_options_info()) {

    $options = array('' => t('None'));

    foreach ($info as $name => $source) {

      $options[$name] = $source['title'];

    }

    $other['options_source'] = array(

      '#title' => t('Load a pre-built option list'),

      '#type' => 'select',

      '#options' => $options,

      '#default_value' => $component['extra']['options_source'],

      '#weight' => 1,

      '#description' => t('Use a pre-built list of options rather than entering options manually. Options will not be editable if using pre-built list.'),

      '#parents' => array('extra', 'options_source'),

      '#weight' => 5,

    );

  }

  if (module_exists('select_or_other')) {

    $other['other_option'] = array(

      '#type' => 'checkbox',

      '#title' => t('Allow "Other..." option'),

      '#default_value' => $component['extra']['other_option'],

      '#description' => t('Check this option if you want to allow users to enter an option not on the list.'),

      '#parents' => array('extra', 'other_option'),

      '#attributes' => array('class' => array('other-option-checkbox')),

      '#weight' => 2,

    );

    $other['other_text'] = array(

      '#type' => 'textfield',

      '#title' => t('Text for "Other..." option'),

      '#default_value' => $component['extra']['other_text'],

      '#description' => t('If allowing other options, enter text to be used for other-enabling option.'),

      '#parents' => array('extra', 'other_text'),

      '#weight' => 3,

      '#states' => array(

        'visible' => array(

          ':input.other-option-checkbox' => array('checked' => TRUE),

        ),

      ),

    );

  }

  if (module_exists('options_element')) {

    $options = _webform_select_options($component, FALSE, FALSE);

    $form['items'] = array(

      '#type' => 'fieldset',

      '#title' => t('Options'),

      '#collapsible' => TRUE,

      '#attributes' => array('class' => array('webform-options-element')),

      '#element_validate' => array('_webform_edit_validate_options'),

      '#weight' => 2,

    );

    $form['items']['options'] = array(

      '#type' => 'options',

      '#limit' => 500,

      '#optgroups' => TRUE,

      '#multiple' => $component['extra']['multiple'],

      '#multiple_toggle' => t('Multiple'),

      '#default_value' => $component['value'],

      '#options' => $options,

      '#options_readonly' => !empty($component['extra']['options_source']),

      '#key_type' => 'mixed',

      '#key_type_toggle' => t('Customize keys (Advanced)'),

      '#key_type_toggled' => $component['extra']['custom_keys'],

      '#default_value_pattern' => '^%.+\[.+\]$',

      '#weight' => 1,

    );

    $form['items']['options']['option_settings'] = $other;

  }

  else {

    $form['extra']['items'] = array(

      '#type' => 'textarea',

      '#title' => t('Options'),

      '#default_value' => $component['extra']['items'],

      '#description' => t('<strong>Key-value pairs MUST be specified as "safe_key|Some readable option"</strong>. Use of only alphanumeric characters and underscores is recommended in keys. One option per line. Option groups may be specified with &lt;Group Name&gt;. &lt;&gt; can be used to insert items at the root of the menu after specifying a group.') . ' ' . theme('webform_token_help'),

      '#cols' => 60,

      '#rows' => 5,

      '#weight' => 0,

      '#required' => TRUE,

      '#wysiwyg' => FALSE,

      '#element_validate' => array('_webform_edit_validate_select'),

    );

    if (!empty($component['extra']['options_source'])) {

      $form['extra']['items']['#attributes'] = array('readonly' => 'readonly');

    }

    $form['extra'] = array_merge($form['extra'], $other);

    $form['value'] = array(

      '#type' => 'textfield',

      '#title' => t('Default value'),

      '#default_value' => $component['value'],

      '#description' => t('The default value of the field identified by its key. For multiple selects use commas to separate multiple defaults.') . ' ' . theme('webform_token_help'),

      '#size' => 60,

      '#maxlength' => 1024,

      '#weight' => 0,

    );

    $form['extra']['multiple'] = array(

      '#type' => 'checkbox',

      '#title' => t('Multiple'),

      '#default_value' => $component['extra']['multiple'],

      '#description' => t('Check this option if the user should be allowed to choose multiple values.'),

      '#weight' => 0,

    );

  }

  $form['display']['aslist'] = array(

    '#type' => 'checkbox',

    '#title' => t('Listbox'),

    '#default_value' => $component['extra']['aslist'],

    '#description' => t('Check this option if you want the select component to be displayed as a select list box instead of radio buttons or checkboxes. Option groups (nested options) are only supported with listbox components.'),

    '#parents' => array('extra', 'aslist'),

  );

  $form['display']['empty_option'] = array(

    '#type' => 'textfield',

    '#title' => t('Empty option'),

    '#default_value' => $component['extra']['empty_option'],

    '#size' => 60,

    '#maxlength' => 255,

    '#description' => t('The list item to show when no default is provided. Leave blank for "- None -" or "- Select -".'),

    '#parents' => array('extra', 'empty_option'),

    '#states' => array(

      'visible' => array(

        ':input[name="extra[aslist]"]' => array('checked' => TRUE),

        ':input[name="extra[multiple]"]' => array('checked' => FALSE),

        ':input[name="value"]' => array('filled' => FALSE),

      ),

    ),

  );

  $form['display']['optrand'] = array(

    '#type' => 'checkbox',

    '#title' => t('Randomize options'),

    '#default_value' => $component['extra']['optrand'],

    '#description' => t('Randomizes the order of the options when they are displayed in the form.'),

    '#parents' => array('extra', 'optrand'),

  );

  return $form;

}

/**

 * Element validation callback. Ensure keys are not duplicated.

 */

function _webform_edit_validate_select($element, &$form_state) {

  // Check for duplicate key values to prevent unexpected data loss. Require

  // all options to include a safe_key.

  if (!empty($element['#value'])) {

    $lines = explode("\n", trim($element['#value']));

    $existing_keys = array();

    $duplicate_keys = array();

    $missing_keys = array();

    $long_keys = array();

    $group = '';

    foreach ($lines as $line) {

      $matches = array();

      $line = trim($line);

      if (preg_match('/^\<([^>]*)\>$/', $line, $matches)) {

        $group = $matches[1];

        $key = NULL; // No need to store group names.

      }

      elseif (preg_match('/^([^|]*)\|(.*)$/', $line, $matches)) {

        $key = $matches[1];

        if (strlen($key) > 128) {

          $long_keys[] = $key;

        }

      }

      else {

        $missing_keys[] = $line;

      }

      if (isset($key)) {

        if (isset($existing_keys[$group][$key])) {

          $duplicate_keys[$key] = $key;

        }

        else {

          $existing_keys[$group][$key] = $key;

        }

      }

    }

    if (!empty($missing_keys)) {

      form_error($element, t('Every option must have a key specified. Specify each option as "safe_key|Some readable option".'));

    }

    if (!empty($long_keys)) {

      form_error($element, t('Option keys must be less than 128 characters. The following keys exceed this limit:') . theme('item_list', $long_keys));

    }

    if (!empty($duplicate_keys)) {

      form_error($element, t('Options within the select list must be unique. The following keys have been used multiple times:') . theme('item_list', array('items' => $duplicate_keys)));

    }

    // Set the listbox option if needed.

    if (empty($missing_keys) && empty($long_keys) && empty($duplicate_keys)) {

      $options = _webform_select_options_from_text($element['#value']);

      _webform_edit_validate_set_aslist($options, $form_state);

    }

  }

  return TRUE;

}

/**

 * Set the appropriate webform values when using the options element module.

 */

function _webform_edit_validate_options($element, &$form_state) {

  $key = end($element['#parents']);

  $element_options = $form_state['values'][$key]['options'];

  unset($form_state['values'][$key]);

  $form_state['values']['extra'][$key] = form_options_to_text($element_options['options'], 'custom');

  // Options saved for select components.

  if ($key == 'items') {

    $form_state['values']['extra']['multiple'] = $element_options['multiple'];

    $form_state['values']['extra']['custom_keys'] = $element_options['custom_keys'];

    $form_state['values']['value'] = is_array($element_options['default_value']) ? implode(', ', $element_options['default_value']) : $element_options['default_value'];

    // Set the listbox option if needed.

    _webform_edit_validate_set_aslist($element_options['options'], $form_state);

  }

  // Options saved for grid components.

  else {

    $form_state['values']['extra']['custom_' . rtrim($key, 's') . '_keys'] = $element_options['custom_keys'];

    // There is only one 'value', but grids have two options widgets, one for questions and one for options.

    // Only options have a default 'value'. Note that multiple selection is now allowed for grid options.

    if ($key == 'options') {

      $form_state['values']['value'] = $element_options['default_value'];

    }

  }

}

/**

 * Ensure "aslist" is used for option groups. Called from options validations.

 */

function _webform_edit_validate_set_aslist($options, &$form_state) {

  if (empty($form_state['values']['extra']['aslist']) && !empty($options)) {

    foreach ($options as $option) {

      if (is_array($option)) {

        $form_state['values']['extra']['aslist'] = 1;

        drupal_set_message(t('The component %name has automatically been set to display as a listbox in order to support option groups.', array('%name' => $form_state['values']['name'])), 'warning');

        break;

      }

    }

  }

}

/**

 * Implements _webform_render_component().

 */

function _webform_render_select($component, $value = NULL, $filter = TRUE, $submission = NULL) {

  $node = isset($component['nid']) ? node_load($component['nid']) : NULL;

  $element = array(

    '#title' => $filter ? webform_filter_xss($component['name']) : $component['name'],

    '#title_display' => $component['extra']['title_display'] ? $component['extra']['title_display'] : 'before',

    '#required' => $component['required'],

    '#weight' => $component['weight'],

    '#description' => $filter ? webform_filter_descriptions($component['extra']['description'], $node) : $component['extra']['description'],

    '#theme_wrappers' => array('webform_element'),

    '#pre_render' => array(), // Needed to disable double-wrapping of radios and checkboxes.

    '#translatable' => array('title', 'description', 'options'),

  );

  // Convert the user-entered options list into an array.

  $default_value = $filter ? webform_replace_tokens($component['value'], $node) : $component['value'];

  $options = _webform_select_options($component, !$component['extra']['aslist'], $filter);

  if (empty($options)) {

    // Make element inaccessible if there are no options as there is no point in showing it.

    $element['#access'] = FALSE;

  }

  if ($component['extra']['optrand']) {

    _webform_shuffle_options($options);

  }

  // Add HTML5 required attribute, if needed and possible (not working on more than one checkboxes).

  if ($component['required'] && ($component['extra']['aslist'] || !$component['extra']['multiple'] || count($options) == 1)) {

    $element['#attributes']['required'] = 'required';

  }

  // Add default options if using a select list with no default. This trigger's

  // Drupal 7's adding of the option for us. See @form_process_select().

  if ($component['extra']['aslist'] && !$component['extra']['multiple'] && $default_value === '') {

    $element['#empty_value'] = '';

    if (strlen($component['extra']['empty_option'])) {

      $element['#empty_option'] =  $component['extra']['empty_option'];

      $element['#translatable'][] = 'empty_option';

    }

  }

  // Set the component options.

  $element['#options'] = $options;

  // Use the component's default value if the component is currently empty.

  if (!isset($value)) {

    // The default for multiple selects is a comma-delimited list, without white-space or empty entries.

    $value = $component['extra']['multiple'] ? array_filter(array_map('trim', explode(',', $default_value)), 'strlen') : $default_value;

  }

  // Convert all values into an array; component may now be single but was previously multiple, or vice-versa

  $value = (array)$value;

  // Set the default value. Note: "No choice" is stored as an empty string,

  // which will match a 0 key for radios; NULL is used to avoid unintentional

  // defaulting to the 0 option.

  if ($component['extra']['multiple']) {

    // Set the value as an array.

    $element['#default_value'] = array();

    foreach ($value as $option_value) {

      $element['#default_value'][] = $option_value === '' ? NULL : $option_value;

    }

  }

  else {

    // Set the value as a single string.

    $option_value = reset($value);

    $element['#default_value'] = $option_value === '' ? NULL : $option_value;

  }

  if ($component['extra']['other_option'] && module_exists('select_or_other')) {

    // Set display as a select_or_other element:

    $element['#type'] = 'select_or_other';

    $element['#other'] = !empty($component['extra']['other_text']) ? check_plain($component['extra']['other_text']) : t('Other...');

    $element['#translatable'][] = 'other';

    $element['#other_title'] = $element['#title'] . ' ' . $element['#other'];

    $element['#other_title_display'] = 'invisible';

    $element['#other_unknown_defaults'] = 'other';

    $element['#other_delimiter'] = ', ';

    // Merge in Webform's #process function for Select or other.

    $element['#process'] = array_merge(element_info_property('select_or_other', '#process'), array('webform_expand_select_or_other'));

    // Inherit select_or_other settings or set defaults.

    $element['#disabled'] = isset($component['extra']['#disabled']) ? $component['extra']['#disabled'] : element_info_property('select_or_other', 'disabled');

    $element['#size'] = isset($component['extra']['#size']) ? $component['extra']['#size'] : element_info_property('select_or_other', 'size');

    if ($component['extra']['multiple']) {

      $element['#multiple'] = TRUE;

      $element['#select_type'] = 'checkboxes';

    }

    else {

      $element['#multiple'] = FALSE;

      $element['#select_type'] = 'radios';

    }

    if ($component['extra']['aslist']) {

      $element['#select_type'] = 'select';

    }

  }

  elseif ($component['extra']['aslist']) {

    // Set display as a select list:

    $element['#type'] = 'select';

    if ($component['extra']['multiple']) {

      $element['#size'] = 4;

      $element['#multiple'] = TRUE;

    }

  }

  else {

    if ($component['extra']['multiple']) {

      // Set display as a checkbox set.

      $element['#type'] = 'checkboxes';

      $element['#theme_wrappers'] = array_merge(array('checkboxes'), $element['#theme_wrappers']);

      $element['#process'] = array_merge(element_info_property('checkboxes', '#process'), array('webform_expand_select_ids'));

    }

    else {

      // Set display as a radio set.

      $element['#type'] = 'radios';

      $element['#theme_wrappers'] = array_merge(array('radios'), $element['#theme_wrappers']);

      $element['#process'] = array_merge(element_info_property('radios', '#process'), array('webform_expand_select_ids'));

    }

  }

  return $element;

}

/**

 * Process function to ensure select_or_other elements validate properly.

 */

function webform_expand_select_or_other($element) {

  // Disable validation for back-button and save draft.

  $element['select']['#validated'] = TRUE;

  $element['select']['#webform_validated'] = FALSE;

  $element['other']['#validated'] = TRUE;

  $element['other']['#webform_validated'] = FALSE;

  // The Drupal FAPI does not support #title_display inline so we need to move

  // to a supported value here to be compatible with select_or_other.

  $element['select']['#title_display'] = $element['#title_display'] === 'inline' ? 'before' : $element['#title_display'];

  // If the default value contains "select_or_other" (the key of the select

  // element for the "other..." choice), discard it and set the "other" value.

  if (is_array($element['#default_value']) && in_array('select_or_other', $element['#default_value'])) {

    $key = array_search('select_or_other', $element['#default_value']);

    unset($element['#default_value'][$key]);

    $element['#default_value'] = array_values($element['#default_value']);

    $element['other']['#default_value'] = implode(', ', $element['#default_value']);

  }

  // Sanitize the options in Select or other check boxes and radio buttons.

  if ($element['#select_type'] == 'checkboxes' || $element['#select_type'] == 'radios') {

    $element['select']['#process'] = array_merge(element_info_property($element['#select_type'], '#process'), array('webform_expand_select_ids'));

  }

  return $element;

}

/**

 * FAPI process function to rename IDs attached to checkboxes and radios.

 */

function webform_expand_select_ids($element) {

  $id = $element['#id'] = str_replace('_', '-', _webform_safe_name(strip_tags($element['#id'])));

  $delta = 0;

  foreach (element_children($element) as $key) {

    $delta++;

    // Convert the #id for each child to a safe name, regardless of key.

    $element[$key]['#id'] = $id . '-' . $delta;

    // Prevent scripts or CSS in the labels for each checkbox or radio.

    $element[$key]['#title'] = isset($element[$key]['#title']) ? webform_filter_xss($element[$key]['#title']) : '';

  }

  return $element;

}

/**

 * Implements _webform_display_component().

 */

function _webform_display_select($component, $value, $format = 'html', $submission = array()) {

  // Sort values by numeric key. These may be in alphabetic order from the database query,

  // which is not numeric order for keys '10' and higher.

  $value = (array) $value;

  ksort($value, SORT_NUMERIC);

  return array(

    '#title' => $component['name'],

    '#title_display' => $component['extra']['title_display'] ? $component['extra']['title_display'] : 'before',

    '#weight' => $component['weight'],

    '#multiple' => $component['extra']['multiple'],

    '#theme' => 'webform_display_select',

    '#theme_wrappers' => $format == 'html' ? array('webform_element') : array('webform_element_text'),

    '#format' => $format,

    '#options' => _webform_select_options($component, !$component['extra']['aslist']),

    '#value' => $value,

    '#translatable' => array('title', 'options'),

  );

}

/**

 * Implements _webform_submit_component().

 *

 * Handle select or other... modifications and convert FAPI 0/1 values into

 * something saveable.

 */

function _webform_submit_select($component, $value) {

  if (module_exists('select_or_other') && $component['extra']['other_option'] && is_array($value) && count($value) == 2 && isset($value['select'])) {

    if (is_array($value['select']) && isset($value['select']['select_or_other'])) {

      unset($value['select']['select_or_other']);

      $value['select'][] = $value['other'];

    }

    elseif ($value['select'] == 'select_or_other') {

      $value['select'] = $value['other'];

    }

    $value = $value['select'];

  }

  // Build a list of all valid keys expected to be submitted.

  $options = _webform_select_options($component, TRUE);

  $return = NULL;

  if (is_array($value)) {

    $return = array();

    foreach ($value as $key => $option_value) {

      // Handle options that are specified options.

      if ($option_value !== '' && isset($options[$option_value])) {

        // Checkboxes submit an integer value of 0 when unchecked. A checkbox

        // with a value of '0' is valid, so we can't use empty() here.

        if ($option_value === 0 && !$component['extra']['aslist'] && $component['extra']['multiple']) {

          // Don't save unchecked values

        }

        else {

          $return[] = $option_value;

        }

      }

      // Handle options that are added through the "other" field. Specifically

      // exclude the "select_or_other" value, which is added by the select list.

      elseif ($component['extra']['other_option'] && module_exists('select_or_other') && $option_value != 'select_or_other') {

        $return[] = $option_value;

      }

    }

    // If no elements are selected, then save an empty string to indicate that this components should not be defaulted again

    if (!$return) {

      $return = array('');

    }

  }

  elseif (is_string($value)) {

    $return = $value;

  }

  return $return;

}

/**

 * Format the text output for this component.

 */

function theme_webform_display_select($variables) {

  $element = $variables['element'];

  // Flatten the list of options so we can get values easily. These options

  // may be translated by hook_webform_display_component_alter().

  $options = array();

  foreach ($element['#options'] as $key => $value) {

    if (is_array($value)) {

      foreach ($value as $subkey => $subvalue) {

        $options[$subkey] = $subvalue;

      }

    }

    else {

      $options[$key] = $value;

    }

  }

  $items = array();

  if ($element['#multiple']) {

    foreach ((array) $element['#value'] as $option_value) {

      if ($option_value !== '') {

        // Administer provided values.

        if (isset($options[$option_value])) {

          $items[] = $element['#format'] == 'html' ? webform_filter_xss($options[$option_value]) : $options[$option_value];

        }

        // User-specified in the "other" field.

        else {

          $items[] = $element['#format'] == 'html' ? check_plain($option_value) : $option_value;

        }

      }

    }

  }

  else {

    if (isset($element['#value'][0]) && $element['#value'][0] !== '') {

      // Administer provided values.

      if (isset($options[$element['#value'][0]])) {

        $items[] = $element['#format'] == 'html' ? webform_filter_xss($options[$element['#value'][0]]) : $options[$element['#value'][0]];

      }

      // User-specified in the "other" field.

      else {

        $items[] = $element['#format'] == 'html' ? check_plain($element['#value'][0]) : $element['#value'][0];

      }

    }

  }

  if ($element['#format'] == 'html') {

    $output = count($items) > 1 ? theme('item_list', array('items' => $items)) : (isset($items[0]) ? $items[0] : ' ');

  }

  else {

    if (count($items) > 1) {

      foreach ($items as $key => $item) {

        $items[$key] = ' - ' . $item;

      }

      $output = implode("\n", $items);

    }

    else {

      $output = isset($items[0]) ? $items[0] : ' ';

    }

  }

  return $output;

}

/**

 * Implements _webform_analysis_component().

 */

function _webform_analysis_select($component, $sids = array(), $single = FALSE, $join = NULL) {

  $options = _webform_select_options($component, TRUE);

  // Create a generic query for the component.

  $query = db_select('webform_submitted_data', 'wsd', array('fetch' => PDO::FETCH_ASSOC))

    ->condition('wsd.nid', $component['nid'])

    ->condition('wsd.cid', $component['cid'])

    ->condition('wsd.data', '', '<>');

  if ($sids) {

    $query->condition('wsd.sid', $sids, 'IN');

  }

  if ($join) {

    $query->innerJoin($join, 'ws2_', 'wsd.sid = ws2_.sid');

  }

  // Clone the query for later use, if needed.

  if ($component['extra']['other_option']) {

    $count_query = clone $query;

    if ($single) {

      $other_query = clone $query;

    }

  }

  $rows = array();

  $other = array();

  $normal_count = 0;

  if ($options) {

    // Gather the normal results first (not "other" options).

    $query->addExpression('COUNT(wsd.data)', 'datacount');

    $result = $query

      ->condition('wsd.data', array_keys($options), 'IN')

      ->fields('wsd', array('data'))

      ->groupBy('wsd.data')

      ->execute();

    foreach ($result as $data) {

      $display_option = isset($options[$data['data']]) ? $options[$data['data']] : $data['data'];

      $rows[$data['data']] = array(webform_filter_xss($display_option), $data['datacount']);

      $normal_count += $data['datacount'];

    }

    // Order the results according to the normal options array.

    $ordered_rows = array();

    foreach (array_intersect_key($options, $rows) as $key => $label) {

      $ordered_rows[] = $rows[$key];

    }

    $rows = $ordered_rows;

  }

  // Add a row for displaying the total unknown or user-entered values.

  if ($component['extra']['other_option']) {

    $count_query->addExpression('COUNT(*)', 'datacount');

    $full_count = $count_query->execute()->fetchField();

    $other_count = $full_count - $normal_count;

    $display_option = !empty($component['extra']['other_text']) ? check_plain($component['extra']['other_text']) : t('Other...');

    $other_text = ($other_count && !$single) ? $other_count . ' (' . l(t('view'), 'node/' . $component['nid'] . '/webform-results/analysis/' . $component['cid']) . ')' : $other_count;

    $rows[] = array($display_option, $other_text);

    // If showing all results, execute the "other" query and append their rows.

    if ($single) {

      $other_query->addExpression('COUNT(wsd.data)', 'datacount');

      $other_query

        ->fields('wsd', array('data'))

        ->groupBy('wsd.data');

      if ($options) {

        $other_query->condition('wsd.data', array_keys($options), 'NOT IN');

      }

      $other_result = $other_query->execute();

      foreach ($other_result as $data) {

        $other[] = array(check_plain($data['data']), $data['datacount']);

      }

      if ($other) {

        array_unshift($other, '<strong>' . t('Other responses') . '</strong>');

      }

    }

  }

  return array(

    'table_rows' => $rows,

    'other_data' => $other,

  );

}

/**

 * Implements _webform_table_component().

 */

function _webform_table_select($component, $value) {

  // Convert submitted 'safe' values to un-edited, original form.

  $options = _webform_select_options($component, TRUE);

  $value = (array) $value;

  ksort($value, SORT_NUMERIC);

  $items = array();

  // Set the value as a single string.

  foreach ($value as $option_value) {

    if ($option_value !== '') {

      if (isset($options[$option_value])) {

        $items[] = webform_filter_xss($options[$option_value]);

      }

      else {

        $items[] = check_plain($option_value);

      }

    }

  }

  return implode('<br />', $items);

}

/**

 * Implements _webform_action_set_component().

 */

function _webform_action_set_select($component, &$element, &$form_state, $value) {

  // Set the value as an array for multiple select or single value otherwise.

  if ($element['#type'] == 'checkboxes') {

    $checkbox_values = $element['#options'];

    array_walk($checkbox_values, function(&$value, $key) use($value) {

      $value = (int)(strval($key) === $value);

    });

  }

  else {

    $value = $component['extra']['multiple'] ? array($value) : $value;

  }

  $element['#value'] = $value;

  form_set_value($element, $value, $form_state);

}

/**

 * Implements _webform_csv_headers_component().

 */

function _webform_csv_headers_select($component, $export_options) {

  $headers = array(

    0 => array(),

    1 => array(),

    2 => array(),

  );

  if ($component['extra']['multiple'] && $export_options['select_format'] == 'separate') {

    $headers[0][] = '';

    $headers[1][] = $export_options['header_keys'] ? $component['form_key'] : $component['name'];

    $items = _webform_select_options($component, TRUE);

    if ($component['extra']['other_option']) {

      if ($export_options['header_keys']) {

        $other_label = $component['form_key'] . '_other';

      }

      else {

        $other_label = !empty($component['extra']['other_text']) ? check_plain($component['extra']['other_text']) : t('Other...');

      }

      $items[$other_label] = $other_label;

    }

    $count = 0;

    foreach ($items as $key => $item) {

      // Empty column per sub-field in main header.

      if ($count != 0) {

        $headers[0][] = '';

        $headers[1][] = '';

      }

      if ($export_options['select_keys']) {

        $headers[2][] = $key;

      }

      else {

        $headers[2][] = $item;

      }

      $count++;

    }

  }

  else {

    $headers[0][] = '';

    $headers[1][] = '';

    $headers[2][] = $export_options['header_keys'] ? $component['form_key'] : $component['name'];

  }

  return $headers;

}

/**

 * Implements _webform_csv_data_component().

 */

function _webform_csv_data_select($component, $export_options, $value) {

  $options = _webform_select_options($component, TRUE);

  $return = array();

  if ($component['extra']['multiple']) {

    foreach ($options as $key => $item) {

      // Strict search is needed to avoid a key of 0 from matching an empty

      // value.

      $index = array_search((string)$key, (array)$value, TRUE);

      if ($index !== FALSE) {

        if ($export_options['select_format'] == 'separate') {

          $return[] = 'X';

        }

        else {

          $return[] = $export_options['select_keys'] ? $key : $item;

        }

        unset($value[$index]);

      }

      elseif ($export_options['select_format'] == 'separate') {

        $return[] = '';

      }

    }

    // Any remaining items in the $value array will be user-added options.

    if ($component['extra']['other_option']) {

      $return[] = count($value) ? implode(',', $value) : '';

    }

  }

  else {

    $key = $value[0];

    if ($export_options['select_keys']) {

      $return = $key;

    }

    else {

      $return = isset($options[$key]) ? $options[$key] : $key;

    }

  }

  if ($component['extra']['multiple'] && $export_options['select_format'] == 'compact') {

    $return = implode(',', (array) $return);

  }

  return $return;

}

/**

 * Implements _webform_options_component().

 *

 * This function is confusingly an alias of _webform_select_options(). However

 * this version is intended to be accessed publicly via

 * webform_component_invoke(), since it is a Webform "hook", rather than an

 * internal, private function. To get the list of select list options for

 * a component, use:

 *

 * @code

 * $options = webform_component_invoke($component['type'], 'options', $component);

 * @endcode

 */

function _webform_options_select($component, $flat = FALSE) {

  return _webform_select_options($component, $flat);

}

/**

 * Menu callback; Return a predefined list of select options as JSON.

 */

function webform_select_options_ajax($source_name = '') {

  $info = _webform_select_options_info();

  $component['extra']['options_source'] = $source_name;

  if ($source_name && isset($info[$source_name])) {

    $options = _webform_select_options_to_text(_webform_select_options($component, FALSE, FALSE));

  }

  else {

    $options = '';

  }

  $return = array(

    'elementId' => module_exists('options_element') ? 'edit-items-options-options-field-widget' : 'edit-extra-items',

    'options' => $options,

  );

  drupal_json_output($return);

}

/**

 * Generate a list of options for a select list.

 */

function _webform_select_options($component, $flat = FALSE, $filter = TRUE) {

  if ($component['extra']['options_source']) {

    $options = _webform_select_options_callback($component['extra']['options_source'], $component, $flat);

  }

  else {

    $options = _webform_select_options_from_text($component['extra']['items'], $flat);

  }

  // Replace tokens if needed in the options.

  if ($filter) {

    $node = node_load($component['nid']);

    $options = _webform_select_replace_tokens($options, $node);

  }

  return isset($options) ? $options : array();

}

/**

 * Replace tokens in the values of a list of select options.

 */

function _webform_select_replace_tokens($options, $node) {

  foreach ($options as $key => $option) {

    if (is_array($option)) {

      $options[$key] = _webform_select_replace_tokens($option, $node);

    }

    else {

      $options[$key] = webform_replace_tokens($option, $node);

    }

  }

  return $options;

}

/**

 * Load Webform select option info from 3rd party modules.

 */

function _webform_select_options_info() {

  static $info;

  if (!isset($info)) {

    $info = array();

    foreach (module_implements('webform_select_options_info') as $module) {

      $additions = module_invoke($module, 'webform_select_options_info');

      foreach ($additions as $key => $addition) {

        $additions[$key]['module'] = $module;

      }

      $info = array_merge($info, $additions);

    }

    drupal_alter('webform_select_options_info', $info);

  }

  return $info;

}

/**

 * Execute a select option callback.

 *

 * @param $name

 *   The name of the options group.

 * @param $component

 *   The full Webform component.

 * @param $flat

 *   Whether the information returned should exclude any nested groups.

 */

function _webform_select_options_callback($name, $component, $flat = FALSE) {

  $info = _webform_select_options_info();

  // Include any necessary files.

  if (isset($info[$name]['file'])) {

    $pathinfo = pathinfo($info[$name]['file']);

    $path = ($pathinfo['dirname'] ? $pathinfo['dirname'] . '/' : '') . basename($pathinfo['basename'], '.' . $pathinfo['extension']);

    module_load_include($pathinfo['extension'], $info[$name]['module'], $path);

  }

  // Execute the callback function.

  if (isset($info[$name]['options callback']) && function_exists($info[$name]['options callback'])) {

    $function = $info[$name]['options callback'];

    $arguments = array();

    if (isset($info[$name]['options arguments'])) {

      $arguments = $info[$name]['options arguments'];

    }

    return $function($component, $flat, $arguments);

  }

}

/**

 * Utility function to split user-entered values from new-line separated

 * text into an array of options.

 *

 * @param string $text

 *   Text to be converted into a select option array.

 * @param bool $flat

 *   Optional. If specified, return the option array and exclude any optgroups.

 * @return array

 *   An array of options suitable for use as a #options property. Note that

 *   values are not filtered and may contain tokens. Individual values should be

 *   run through webform_replace_tokens() if displaying to an end-user.

 */

function _webform_select_options_from_text($text, $flat = FALSE) {

  static $option_cache = array();

  // Keep each processed option block in an array indexed by the MD5 hash of

  // the option text and the value of the $flat variable.

  $md5 = md5($text);

  // Check if this option block has been previously processed.

  if (!isset($option_cache[$flat][$md5])) {

    $options = array();

    $rows = array_filter(explode("\n", trim($text)));

    $group = NULL;

    foreach ($rows as $option) {

      $option = trim($option);

      /**

       * If the Key of the option is within < >, treat as an optgroup

       *

       * <Group 1>

       *   creates an optgroup with the label "Group 1"

       *

       * <>

       *   Unsets the current group, allowing items to be inserted at the root element.

       */

      if (preg_match('/^\<([^>]*)\>$/', $option, $matches)) {

        if (empty($matches[1])) {

          unset($group);

        }

        elseif (!$flat) {

          $group = $matches[1];

        }

      }

      elseif (preg_match('/^([^|]+)\|(.*)$/', $option, $matches)) {

        $key = $matches[1];

        $value = $matches[2];

        isset($group) ? $options[$group][$key] = $value : $options[$key] = $value;

      }

      else {

        isset($group) ? $options[$group][$option] = $option : $options[$option] = $option;

      }

    }

    $option_cache[$flat][$md5] = $options;

  }

  // Return our options from the option_cache array.

  return $option_cache[$flat][$md5];

}

/**

 * Convert an array of options into text.

 */

function _webform_select_options_to_text($options) {

  $output = '';

  $previous_key = FALSE;

  foreach ($options as $key => $value) {

    // Convert groups.

    if (is_array($value)) {

      $output .= '<' . $key . '>' . "\n";

      foreach ($value as $subkey => $subvalue) {

        $output .= $subkey . '|' . $subvalue . "\n";

      }

      $previous_key = $key;

    }

    // Typical key|value pairs.

    else {

      // Exit out of any groups.

      if (isset($options[$previous_key]) && is_array($options[$previous_key])) {

        $output .= "<>\n";

      }

      // Skip empty rows.

      if ($options[$key] !== '') {

        $output .= $key . '|' . $value . "\n";

      }

      $previous_key = $key;

    }

  }

  return $output;

}

/**

 * Utility function to shuffle an array while preserving key-value pairs.

 */

function _webform_shuffle_options(&$array) {

  // First shuffle the array keys, then use them as the basis for ordering

  // the options.

  $aux = array();

  $keys = array_keys($array);

  shuffle($keys);

  foreach ($keys as $key) {

    $aux[$key] = $array[$key];

  }

  $array = $aux;

}