danielebarchiesi@0: '', danielebarchiesi@0: 'form_key' => NULL, danielebarchiesi@0: 'mandatory' => 0, danielebarchiesi@0: 'pid' => 0, danielebarchiesi@0: 'weight' => 0, danielebarchiesi@0: 'extra' => array( danielebarchiesi@0: 'options' => '', danielebarchiesi@0: 'questions' => '', danielebarchiesi@0: 'optrand' => 0, danielebarchiesi@0: 'qrand' => 0, danielebarchiesi@0: 'title_display' => 0, danielebarchiesi@0: 'custom_option_keys' => 0, danielebarchiesi@0: 'custom_question_keys' => 0, danielebarchiesi@0: 'description' => '', danielebarchiesi@0: 'private' => FALSE, danielebarchiesi@0: ), danielebarchiesi@0: ); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Implements _webform_theme_component(). danielebarchiesi@0: */ danielebarchiesi@0: function _webform_theme_grid() { danielebarchiesi@0: return array( danielebarchiesi@0: 'webform_grid' => array( danielebarchiesi@0: 'render element' => 'element', danielebarchiesi@0: 'file' => 'components/grid.inc', danielebarchiesi@0: ), danielebarchiesi@0: 'webform_display_grid' => array( danielebarchiesi@0: 'render element' => 'element', danielebarchiesi@0: 'file' => 'components/grid.inc', danielebarchiesi@0: ), danielebarchiesi@0: ); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Implements _webform_edit_component(). danielebarchiesi@0: */ danielebarchiesi@0: function _webform_edit_grid($component) { danielebarchiesi@0: $form = array(); danielebarchiesi@0: danielebarchiesi@0: if (module_exists('options_element')) { danielebarchiesi@0: $form['options'] = array( danielebarchiesi@0: '#type' => 'fieldset', danielebarchiesi@0: '#title' => t('Options'), danielebarchiesi@0: '#collapsible' => TRUE, danielebarchiesi@0: '#description' => t('Options to select across the top. Usually these are ratings such as "poor" through "excellent" or "strongly disagree" through "strongly agree".'), danielebarchiesi@0: '#attributes' => array('class' => array('webform-options-element')), danielebarchiesi@0: '#element_validate' => array('_webform_edit_validate_options'), danielebarchiesi@0: ); danielebarchiesi@0: $form['options']['options'] = array( danielebarchiesi@0: '#type' => 'options', danielebarchiesi@0: '#options' => _webform_select_options_from_text($component['extra']['options'], TRUE), danielebarchiesi@0: '#optgroups' => FALSE, danielebarchiesi@0: '#default_value' => FALSE, danielebarchiesi@0: '#default_value_allowed' => FALSE, danielebarchiesi@0: '#optgroups' => FALSE, danielebarchiesi@0: '#key_type' => 'mixed', danielebarchiesi@0: '#key_type_toggle' => t('Customize option keys (Advanced)'), danielebarchiesi@0: '#key_type_toggled' => $component['extra']['custom_option_keys'], danielebarchiesi@0: ); danielebarchiesi@0: danielebarchiesi@0: $form['questions'] = array( danielebarchiesi@0: '#type' => 'fieldset', danielebarchiesi@0: '#title' => t('Questions'), danielebarchiesi@0: '#collapsible' => TRUE, danielebarchiesi@0: '#description' => t('Questions list down the side of the grid.'), danielebarchiesi@0: '#attributes' => array('class' => array('webform-options-element')), danielebarchiesi@0: '#element_validate' => array('_webform_edit_validate_options'), danielebarchiesi@0: ); danielebarchiesi@0: $form['questions']['options'] = array( danielebarchiesi@0: '#type' => 'options', danielebarchiesi@0: '#options' => _webform_select_options_from_text($component['extra']['questions'], TRUE), danielebarchiesi@0: '#optgroups' => FALSE, danielebarchiesi@0: '#default_value' => FALSE, danielebarchiesi@0: '#default_value_allowed' => FALSE, danielebarchiesi@0: '#optgroups' => FALSE, danielebarchiesi@0: '#key_type' => 'mixed', danielebarchiesi@0: '#key_type_toggle' => t('Customize question keys (Advanced)'), danielebarchiesi@0: '#key_type_toggled' => $component['extra']['custom_question_keys'], danielebarchiesi@0: ); danielebarchiesi@0: } danielebarchiesi@0: else { danielebarchiesi@0: $form['extra']['options'] = array( danielebarchiesi@0: '#type' => 'textarea', danielebarchiesi@0: '#title' => t('Options'), danielebarchiesi@0: '#default_value' => $component['extra']['options'], danielebarchiesi@0: '#description' => t('Options to select across the top. One option per line. Key-value pairs MUST be specified as "safe_key|Some readable option". Use of only alphanumeric characters and underscores is recommended in keys.') . theme('webform_token_help'), danielebarchiesi@0: '#cols' => 60, danielebarchiesi@0: '#rows' => 5, danielebarchiesi@0: '#weight' => -3, danielebarchiesi@0: '#required' => TRUE, danielebarchiesi@0: '#wysiwyg' => FALSE, danielebarchiesi@0: '#element_validate' => array('_webform_edit_validate_select'), danielebarchiesi@0: ); danielebarchiesi@0: $form['extra']['questions'] = array( danielebarchiesi@0: '#type' => 'textarea', danielebarchiesi@0: '#title' => t('Questions'), danielebarchiesi@0: '#default_value' => $component['extra']['questions'], danielebarchiesi@0: '#description' => t('Questions list down the side of the grid. One question per line. Key-value pairs MUST be specified as "safe_key|Some readable option". Use of only alphanumeric characters and underscores is recommended in keys.') . theme('webform_token_help'), danielebarchiesi@0: '#cols' => 60, danielebarchiesi@0: '#rows' => 5, danielebarchiesi@0: '#weight' => -2, danielebarchiesi@0: '#required' => TRUE, danielebarchiesi@0: '#wysiwyg' => FALSE, danielebarchiesi@0: '#element_validate' => array('_webform_edit_validate_select'), danielebarchiesi@0: ); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: $form['display']['optrand'] = array( danielebarchiesi@0: '#type' => 'checkbox', danielebarchiesi@0: '#title' => t('Randomize Options'), danielebarchiesi@0: '#default_value' => $component['extra']['optrand'], danielebarchiesi@0: '#description' => t('Randomizes the order of options on the top when they are displayed in the form.'), danielebarchiesi@0: '#parents' => array('extra', 'optrand') danielebarchiesi@0: ); danielebarchiesi@0: $form['display']['qrand'] = array( danielebarchiesi@0: '#type' => 'checkbox', danielebarchiesi@0: '#title' => t('Randomize Questions'), danielebarchiesi@0: '#default_value' => $component['extra']['qrand'], danielebarchiesi@0: '#description' => t('Randomize the order of the questions on the side when they are displayed in the form.'), danielebarchiesi@0: '#parents' => array('extra', 'qrand') danielebarchiesi@0: ); danielebarchiesi@0: return $form; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Implements _webform_render_component(). danielebarchiesi@0: */ danielebarchiesi@0: function _webform_render_grid($component, $value = NULL, $filter = TRUE) { danielebarchiesi@0: $node = isset($component['nid']) ? node_load($component['nid']) : NULL; danielebarchiesi@0: danielebarchiesi@0: $element = array( danielebarchiesi@0: '#type' => 'webform_grid', danielebarchiesi@0: '#title' => $filter ? _webform_filter_xss($component['name']) : $component['name'], danielebarchiesi@0: '#title_display' => $component['extra']['title_display'] ? $component['extra']['title_display'] : 'before', danielebarchiesi@0: '#required' => $component['mandatory'], danielebarchiesi@0: '#weight' => $component['weight'], danielebarchiesi@0: '#description' => $filter ? _webform_filter_descriptions($component['extra']['description'], $node) : $component['extra']['description'], danielebarchiesi@0: '#grid_questions' => _webform_select_options_from_text($component['extra']['questions'], TRUE), danielebarchiesi@0: '#grid_options' => _webform_select_options_from_text($component['extra']['options'], TRUE), danielebarchiesi@0: '#optrand' => $component['extra']['optrand'], danielebarchiesi@0: '#qrand' => $component['extra']['qrand'], danielebarchiesi@0: '#theme' => 'webform_grid', danielebarchiesi@0: '#theme_wrappers' => array('webform_element'), danielebarchiesi@0: '#process' => array('webform_expand_grid'), danielebarchiesi@0: '#translatable' => array('title', 'description', 'grid_options', 'grid_questions'), danielebarchiesi@0: ); danielebarchiesi@0: danielebarchiesi@0: if ($value) { danielebarchiesi@0: $element['#default_value'] = $value; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: return $element; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * A Form API #process function for Webform grid fields. danielebarchiesi@0: */ danielebarchiesi@0: function webform_expand_grid($element) { danielebarchiesi@0: $options = $element['#grid_options']; danielebarchiesi@0: $questions = $element['#grid_questions']; danielebarchiesi@0: danielebarchiesi@0: if (!empty($element['#optrand'])) { danielebarchiesi@0: _webform_shuffle_options($options); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: if (!empty($element['#qrand'])) { danielebarchiesi@0: _webform_shuffle_options($questions); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: foreach ($questions as $key => $question) { danielebarchiesi@0: if ($question != '') { danielebarchiesi@0: $element[$key] = array( danielebarchiesi@0: '#title' => $question, danielebarchiesi@0: '#required' => $element['#required'], danielebarchiesi@0: '#options' => $options, danielebarchiesi@0: '#type' => 'radios', danielebarchiesi@0: '#process' => array('form_process_radios', 'webform_expand_select_ids'), danielebarchiesi@0: danielebarchiesi@0: // Webform handles validation manually. danielebarchiesi@0: '#validated' => TRUE, danielebarchiesi@0: '#webform_validated' => FALSE, danielebarchiesi@0: '#translatable' => array('title'), danielebarchiesi@0: ); danielebarchiesi@0: } danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: $value = isset($element['#default_value']) ? $element['#default_value'] : array(); danielebarchiesi@0: foreach (element_children($element) as $key) { danielebarchiesi@0: if (isset($value[$key])) { danielebarchiesi@0: $element[$key]['#default_value'] = ($value[$key] !== '') ? $value[$key] : NULL; danielebarchiesi@0: } danielebarchiesi@0: else { danielebarchiesi@0: $element[$key]['#default_value'] = NULL; danielebarchiesi@0: } danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: return $element; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Implements _webform_display_component(). danielebarchiesi@0: */ danielebarchiesi@0: function _webform_display_grid($component, $value, $format = 'html') { danielebarchiesi@0: $questions = _webform_select_options_from_text($component['extra']['questions'], TRUE); danielebarchiesi@0: $options = _webform_select_options_from_text($component['extra']['options'], TRUE); danielebarchiesi@0: danielebarchiesi@0: $element = array( danielebarchiesi@0: '#title' => $component['name'], danielebarchiesi@0: '#weight' => $component['weight'], danielebarchiesi@0: '#format' => $format, danielebarchiesi@0: '#grid_questions' => $questions, danielebarchiesi@0: '#grid_options' => $options, danielebarchiesi@0: '#theme' => 'webform_display_grid', danielebarchiesi@0: '#theme_wrappers' => $format == 'html' ? array('webform_element') : array('webform_element_text'), danielebarchiesi@0: '#sorted' => TRUE, danielebarchiesi@0: '#translatable' => array('#title', '#grid_questions', '#grid_options'), danielebarchiesi@0: ); danielebarchiesi@0: danielebarchiesi@0: foreach ($questions as $key => $question) { danielebarchiesi@0: if ($question !== '') { danielebarchiesi@0: $element[$key] = array( danielebarchiesi@0: '#title' => $question, danielebarchiesi@0: '#value' => isset($value[$key]) ? $value[$key] : NULL, danielebarchiesi@0: '#translatable' => array('#title', '#value'), danielebarchiesi@0: ); danielebarchiesi@0: } danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: return $element; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Format the text output for this component. danielebarchiesi@0: */ danielebarchiesi@0: function theme_webform_display_grid($variables) { danielebarchiesi@0: $element = $variables['element']; danielebarchiesi@0: danielebarchiesi@0: $component = $element['#webform_component']; danielebarchiesi@0: $format = $element['#format']; danielebarchiesi@0: danielebarchiesi@0: if ($format == 'html') { danielebarchiesi@0: $rows = array(); danielebarchiesi@0: $header = array(array('data' => '', 'class' => array('webform-grid-question'))); danielebarchiesi@0: foreach ($element['#grid_options'] as $option) { danielebarchiesi@0: $header[] = array('data' => _webform_filter_xss($option), 'class' => array('checkbox', 'webform-grid-option')); danielebarchiesi@0: } danielebarchiesi@0: foreach ($element['#grid_questions'] as $question_key => $question) { danielebarchiesi@0: $row = array(); danielebarchiesi@0: $row[] = array('data' => _webform_filter_xss($question), 'class' => array('webform-grid-question')); danielebarchiesi@0: foreach ($element['#grid_options'] as $option_value => $option_label) { danielebarchiesi@0: if (strcmp($element[$question_key]['#value'], $option_value) == 0) { danielebarchiesi@0: $row[] = array('data' => 'X', 'class' => array('checkbox', 'webform-grid-option')); danielebarchiesi@0: } danielebarchiesi@0: else { danielebarchiesi@0: $row[] = array('data' => ' ', 'class' => array('checkbox', 'webform-grid-option')); danielebarchiesi@0: } danielebarchiesi@0: } danielebarchiesi@0: $rows[] = $row; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: $option_count = count($header) - 1; danielebarchiesi@0: $output = theme('table', array('header' => $header, 'rows' => $rows, 'attributes' => array('class' => array('webform-grid', 'webform-grid-' . $option_count)))); danielebarchiesi@0: } danielebarchiesi@0: else { danielebarchiesi@0: $items = array(); danielebarchiesi@0: foreach (element_children($element) as $key) { danielebarchiesi@0: $items[] = ' - ' . $element[$key]['#title'] . ': ' . (isset($element['#grid_options'][$element[$key]['#value']]) ? $element['#grid_options'][$element[$key]['#value']] : ''); danielebarchiesi@0: } danielebarchiesi@0: $output = implode("\n", $items); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: return $output; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Implements _webform_analysis_component(). danielebarchiesi@0: */ danielebarchiesi@0: function _webform_analysis_grid($component, $sids = array()) { danielebarchiesi@0: // Generate the list of options and questions. danielebarchiesi@0: $options = _webform_select_options_from_text($component['extra']['options'], TRUE); danielebarchiesi@0: $questions = _webform_select_options_from_text($component['extra']['questions'], TRUE); danielebarchiesi@0: danielebarchiesi@0: // Generate a lookup table of results. danielebarchiesi@0: $query = db_select('webform_submitted_data', 'wsd') danielebarchiesi@0: ->fields('wsd', array('no', 'data')) danielebarchiesi@0: ->condition('nid', $component['nid']) danielebarchiesi@0: ->condition('cid', $component['cid']) danielebarchiesi@0: ->condition('data', '', '<>') danielebarchiesi@0: ->groupBy('no') danielebarchiesi@0: ->groupBy('data'); danielebarchiesi@0: $query->addExpression('COUNT(sid)', 'datacount'); danielebarchiesi@0: danielebarchiesi@0: if (count($sids)) { danielebarchiesi@0: $query->condition('sid', $sids, 'IN'); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: $result = $query->execute(); danielebarchiesi@0: $counts = array(); danielebarchiesi@0: foreach ($result as $data) { danielebarchiesi@0: $counts[$data->no][$data->data] = $data->datacount; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: // Create an entire table to be put into the returned row. danielebarchiesi@0: $rows = array(); danielebarchiesi@0: $header = array(''); danielebarchiesi@0: danielebarchiesi@0: // Add options as a header row. danielebarchiesi@0: foreach ($options as $option) { danielebarchiesi@0: $header[] = _webform_filter_xss($option); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: // Add questions as each row. danielebarchiesi@0: foreach ($questions as $qkey => $question) { danielebarchiesi@0: $row = array(_webform_filter_xss($question)); danielebarchiesi@0: foreach ($options as $okey => $option) { danielebarchiesi@0: $row[] = !empty($counts[$qkey][$okey]) ? $counts[$qkey][$okey] : 0; danielebarchiesi@0: } danielebarchiesi@0: $rows[] = $row; danielebarchiesi@0: } danielebarchiesi@0: $output = theme('table', array('header' => $header, 'rows' => $rows, 'attributes' => array('class' => array('webform-grid')))); danielebarchiesi@0: danielebarchiesi@0: danielebarchiesi@0: return array(array(array('data' => $output, 'colspan' => 2))); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Implements _webform_table_component(). danielebarchiesi@0: */ danielebarchiesi@0: function _webform_table_grid($component, $value) { danielebarchiesi@0: $questions = _webform_select_options_from_text($component['extra']['questions'], TRUE); danielebarchiesi@0: $options = _webform_select_options_from_text($component['extra']['options'], TRUE); danielebarchiesi@0: danielebarchiesi@0: $output = ''; danielebarchiesi@0: // Set the value as a single string. danielebarchiesi@0: foreach ($questions as $key => $label) { danielebarchiesi@0: if (isset($value[$key]) && isset($options[$value[$key]])) { danielebarchiesi@0: $output .= _webform_filter_xss($label) . ': ' . _webform_filter_xss($options[$value[$key]]) . '
'; danielebarchiesi@0: } danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: return $output; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Implements _webform_csv_headers_component(). danielebarchiesi@0: */ danielebarchiesi@0: function _webform_csv_headers_grid($component, $export_options) { danielebarchiesi@0: $header = array(); danielebarchiesi@0: $header[0] = array(''); danielebarchiesi@0: $header[1] = array($component['name']); danielebarchiesi@0: $items = _webform_select_options_from_text($component['extra']['questions'], TRUE); danielebarchiesi@0: $count = 0; danielebarchiesi@0: foreach ($items as $key => $item) { danielebarchiesi@0: // Empty column per sub-field in main header. danielebarchiesi@0: if ($count != 0) { danielebarchiesi@0: $header[0][] = ''; danielebarchiesi@0: $header[1][] = ''; danielebarchiesi@0: } danielebarchiesi@0: // The value for this option. danielebarchiesi@0: $header[2][] = $item; danielebarchiesi@0: $count++; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: return $header; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: /** danielebarchiesi@0: * Implements _webform_csv_data_component(). danielebarchiesi@0: */ danielebarchiesi@0: function _webform_csv_data_grid($component, $export_options, $value) { danielebarchiesi@0: $questions = _webform_select_options_from_text($component['extra']['questions'], TRUE); danielebarchiesi@0: $options = _webform_select_options_from_text($component['extra']['options'], TRUE); danielebarchiesi@0: $return = array(); danielebarchiesi@0: foreach ($questions as $key => $question) { danielebarchiesi@0: if (isset($value[$key]) && isset($options[$value[$key]])) { danielebarchiesi@0: $return[] = $export_options['select_keys'] ? $value[$key] : $options[$value[$key]]; danielebarchiesi@0: } danielebarchiesi@0: else { danielebarchiesi@0: $return[] = ''; danielebarchiesi@0: } danielebarchiesi@0: } danielebarchiesi@0: return $return; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: function theme_webform_grid($variables) { danielebarchiesi@0: $element = $variables['element']; danielebarchiesi@0: danielebarchiesi@0: $rows = array(); danielebarchiesi@0: $header = array(array('data' => '', 'class' => array('webform-grid-question'))); danielebarchiesi@0: // Set the header for the table. danielebarchiesi@0: foreach ($element['#grid_options'] as $option) { danielebarchiesi@0: $header[] = array('data' => _webform_filter_xss($option), 'class' => array('checkbox', 'webform-grid-option')); danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: foreach (element_children($element) as $key) { danielebarchiesi@0: $question_element = $element[$key]; danielebarchiesi@0: danielebarchiesi@0: // Create a row with the question title. danielebarchiesi@0: $row = array(array('data' => _webform_filter_xss($question_element['#title']), 'class' => array('webform-grid-question'))); danielebarchiesi@0: danielebarchiesi@0: // Render each radio button in the row. danielebarchiesi@0: $radios = form_process_radios($question_element); danielebarchiesi@0: foreach (element_children($radios) as $key) { danielebarchiesi@0: $radios[$key]['#title_display'] = 'invisible'; danielebarchiesi@0: $row[] = array('data' => drupal_render($radios[$key]), 'class' => array('checkbox', 'webform-grid-option')); danielebarchiesi@0: } danielebarchiesi@0: $rows[] = $row; danielebarchiesi@0: } danielebarchiesi@0: danielebarchiesi@0: $option_count = count($header) - 1; danielebarchiesi@0: return theme('table', array('header' => $header, 'rows' => $rows, 'attributes' => array('class' => array('webform-grid', 'webform-grid-' . $option_count)))); danielebarchiesi@0: }