Club Drupal

/**

 * @file

 *

 * @author Nathan Haug <nate@lullabot.com>

 */

  // Determine whether views or hard-coded tables should be used for the

  // submissions table.

  if (!webform_variable_get('webform_table')) {

    $view = webform_get_view($node, 'webform_submissions');

    if ($user_filter) {

      if ($user->uid) {

  $element['table']['#rows'] = $rows;

  $element['table']['#operation_total'] = $operation_total;

}

/**

 *   Loaded webform node.

 * @param string $view_id

 *   machine_id of the view, such as webform_results or webform_submissions.

 *   The loaded view.

 */

function webform_get_view($node, $view_id) {

}

/**

 */

function template_preprocess_webform_results_submissions(&$vars) {

  $vars['node'] = $vars['element']['#node'];

  $vars['table'] = $vars['element']['table'];

  $vars['total_count'] = $vars['element']['#total_count'];

  $vars['pager_count'] = $vars['element']['#pager_count'];

  unset($vars['element']);

}

  // Determine whether views or hard-coded tables should be used for the

  // submissions table.

  if (!webform_variable_get('webform_table')) {

    $view = webform_get_view($node, 'webform_results');

    return $view->preview('default', array($node->nid));

  }

  if (isset($_GET['results']) && is_numeric($_GET['results'])) {

    $pager_count = $_GET['results'];

  }

  $submissions = webform_get_submissions($node->nid, $header, $pager_count);

  $total_count = webform_get_submission_count($node->nid, NULL, NULL);

  if ($pager_count) {

  }

  return $output;

}

function theme_webform_results_table_header($variables) {

  return array(

    array('data' => t('#'), 'field' => 'sid', 'sort' => 'desc'),

  drupal_add_library('webform', 'admin');

  $node = $variables['node'];

  $submissions = $variables['submissions'];

  $total_count = $variables['total_count'];

  $pager_count = $variables['pager_count'];

  $rows = array();

  $cell = array();

    $rows[] = array(array('data' => t('There are no submissions for this form. <a href="!url">View this form</a>.', array('!url' => url('node/' . $node->nid))), 'colspan' => 4));

  }

  $output = '';

  $output .= theme('webform_results_per_page', array('total_count' => $total_count, 'pager_count' => $pager_count));

  $output .= theme('table', array('header' => $header, 'rows' => $rows));

 *   The node id whose submissions will be deleted.

 * @param $batch_size

 *   The number of submissions to be processed. NULL means all submissions.

 * @return

 *   The number of submissions processed.

 */

  return confirm_form($form, $question, 'node/' . $node->nid . '/webform-results', NULL, t('Clear'), t('Cancel'));

}

function webform_results_clear_form_submit($form, &$form_state) {

  $nid = $form_state['values']['nid'];

  $node = node_load($nid);

  $count = webform_results_clear($node->nid, $batch_size);

  $context['results']['count'] += $count;

  $context['message'] = t('Cleared @count of @total submissions...', array('@count' => $context['results']['count'], '@total' => $context['results']['total']));

  $context['finished'] = $count > 0

                            ? $context['results']['count'] / $context['results']['total']

    '#type' => 'container',

    'warning' => array(

      '#markup' => '<p>' .

        array('!link' => url('https://www.google.com/search?q=spreadsheet+formula+injection'))) .

    ),

    'delimiter' => array(

      '#type' => 'select',

  // programmatically submitting this form.

  $form['download'] = array(

    '#type' => 'value',

  );

  $form['actions'] = array('#type' => 'actions');

        }

      }

      break;

    case 'range_serial':

      // Download Start-End range of submissions.

      // Start submission number.

        }

      }

      break;

    case 'range_date':

      // Download Start-end range of submissions.

      // Start submission time.

  $element['range_type']['new']['#theme_wrappers'] = array('webform_inline_radio');

  $element['range_type']['new']['#title'] .= ' (' . t('@count new since @date', array('@count' => $download_info['new'], '@date' => $requested_date)) . ')';

  // Disable option if there are no new submissions.

  if ($download_info['new'] == 0) {

    $element['range_type']['new']['#attributes']['disabled'] = 'disabled';

  $element['range_type']['range_serial']['#title'] = t('Submissions by number from !start and optionally to: !end   (Last downloaded: !serial)',

    array('!start' => drupal_render($element['start']), '!end' => drupal_render($element['end']), '!serial' => $last_serial));

  $element['range_type']['range_date']['#theme_wrappers'] = array('webform_inline_radio');

  $element['range_type']['range_date']['#title'] = t('Submissions by date from !start_date and optionally to: !end_date', array('!start_date' => drupal_render($element['start_date']), '!end_date' => drupal_render($element['end_date'])));

 *

 * @param object $node

 *   The webform node.

 *   The number of submissions to be processed at once.

 */

function webform_export_batch_size($node) {

        // Allow modules to modify the component CSV header.

        drupal_alter('webform_csv_header', $component_header, $component);

        $header[0] = array_merge($header[0], (array) $component_header[0]);

        $header[1] = array_merge($header[1], (array) $component_header[1]);

        $header[2] = array_merge($header[2], (array) $component_header[2]);

 * @param $last_sid

 *   If set to a non-NULL value, the last sid will be returned.

 *

 *   An array of rows built according to the provided $serial_start and

 *   $pager_count variables. Note that the current page number is determined

 *   by the super-global $_GET['page'] variable.

 * @param array $submissions

 *   An associative array of loaded submissions, indexed by sid.

 *

 *   An array of rows built according to the provided $serial_start and

 *   $pager_count variables. Note that the current page number is determined

 *   by the super-global $_GET['page'] variable.

  switch ($token) {

    case 'webform_serial':

      return $submission->serial;

    case 'webform_sid':

      return $submission->sid;

    case 'webform_time':

      // Return timestamp in local time (not UTC).

      if (!empty($options['iso8601_date'])) {

      }

    case 'webform_draft':

      return $submission->is_draft;

    case 'webform_ip_address':

      return $submission->remote_addr;

    case 'webform_uid':

      return $submission->uid;

    case 'webform_username':

      return $submission->name;

  }

  else {

    $export_name = _webform_safe_name($node->title);

    if (!strlen($export_name)) {

    }

    $export_info['exporter']->set_headers($export_name);

    ob_clean();

  }

  // Save the last exported sid for new-only exports.

  @fclose($handle);

  $context['message'] = t('Exported @count of @total submissions...', array('@count' => $context['sandbox']['serial'], '@total' => $context['sandbox']['sid_count']));

  $context['finished'] = $context['sandbox']['batch_number'] < $context['sandbox']['batch_max']

                            ? $context['sandbox']['batch_number'] / $context['sandbox']['batch_max']

  if (!$handle) {

    return;

  }

  $exporter->eof($handle, $context['results']['row_count'], $context['results']['col_count']);

  @fclose($handle);

}

 *   relating specifically to that component's analysis, such as a list of

 *   "Other" values within a select list.

 *

 */

function webform_results_analysis($node, $sids = array(), $analysis_component = NULL) {

  if (!is_array($sids)) {

  }

  drupal_alter('webform_analysis', $analysis);

}

/**

        $data['table_rows'][] = $other_data;

      }

      else {

      }

    }

  }

 *

 * @param $node

 *   The node whose components' data is being analyzed.

 * @return array

 *   An array of component IDs.

 */

function theme_webform_results_analysis($variables) {

  $node = $variables['node'];

  $data = $variables['data'];

  $analysis_component = $variables['component'];

  $rows = array();

  $header = array(

    $single ? $analysis_component['name'] : t('Q'),

  );

  foreach ($data as $cid => $row_data) {

 *

 * @deprecated This function is scheduled to be removed int webform 7.x-5.x.

 * Use webform_download_sids_query() instead.

 */

function webform_download_sids($nid, $range_options, $uid = NULL) {

  return webform_download_sids_query($nid, $range_options, $uid)

/**

 * Retrieves a count the number of matching submissions.

 */

function webform_download_sids_count($nid, $range_options, $uid = NULL) {

  return webform_download_sids_query($nid, $range_options, $uid)

 * The query will have no fields as they should be added by the caller as

 * desired.

 *

 *   The node id of the webform.

 * @param array $range_options

 *   Associate array of range options.

 *   The user id of the user whose last download information should be used,

 *   or the current user if NULL. This is unrelated to which user submitted

 *   the submissions.

      // All Submissions.

      $query->orderBy('ws.sid', 'ASC');

      break;

    case 'new':

      // All Since Last Download.

      $download_info = webform_download_last_download_info($nid, $uid);

        ->condition('ws.sid', $last_sid, '>')

        ->orderBy('ws.sid', 'ASC');

      break;

    case 'latest':

      // Last x Submissions.

      $start_sid = webform_download_latest_start_sid($nid, $range_options['latest'], $range_options['completion_type']);

      $query->condition('ws.sid', $start_sid, '>=');

      break;

    case 'range':

      // Submissions Start-End.

      $query->condition('ws.sid', $range_options['start'], '>=');

      }

      $query->orderBy('ws.sid', 'ASC');

      break;

    case 'range_serial':

      // Submissions Start-End, using serial numbers.

      $query->condition('ws.serial', $range_options['start'], '>=');

      }

      $query->orderBy('ws.serial', 'ASC');

      break;

    case 'range_date':

      $date_field = $range_options['completion_type'] == 'finished' ? 'ws.completed' : 'ws.submitted';

      $query->condition($date_field, strtotime($range_options['start_date']), '>=');

      if ($range_options['end_date'] != '' && ($end_time = strtotime($range_options['end_date'])) !== FALSE) {

        if ($end_time == strtotime('midnight', $end_time)) {

          // Full day specified

        }

        $query->condition($date_field, $end_time, '<=');

      $query->orderBy($date_field, 'ASC');

      break;

  }

 *   The Webform NID.

 * @param $uid

 *   The user account ID for which to retrieve download information.

 * @return

 *   An array of download information or FALSE if this user has never downloaded

 *   results for this particular node.

 *   The latest count on which the SID will be retrieved.

 * @param string $completion_type

 *   The completion type, either "finished", "draft", or "all".

 * @return

 *   The submission ID that starts the latest sequence of submissions.

 */