Club Drupal

 * @param array $variables

 *   An array with keys:

 *    - node: The node whose results are being displayed.

 *    - components: An associative array of the components for this webform.

 *    - submissions: An array of all submissions for this webform.

 *    - total_count: The total number of submissions to this webform.

 *    - pager_count: The number of results to be shown per page.

function theme_webform_results_table(array $variables) {

  $components = $variables['components'];

    foreach ($components as $component) {

  $element['#webform_download_info']['new'] = webform_download_sids_count($node->nid, array('range_type' => 'new', 'completion_type' => 'finished'));

  if ($node->webform['allow_draft'] || $node->webform['auto_save']) {

    $element['#webform_download_info']['new_draft'] = webform_download_sids_count($node->nid, array('range_type' => 'new', 'completion_type' => 'draft'));

  }

  if (isset($download_info['new_draft'])) {

    $args = array(

      '@new_draft' => $download_info['new_draft'],

      '@new' => $download_info['new'],

      '@date' => $requested_date,

    );

    $element['range_type']['new']['#title'] .= ' (' . t('@new_draft new drafts, @new new finished since @date', $args) . ')';

    $total_count = $download_info['new_draft'] + $download_info['new'];

  }

  else {

    $args = array(

      '@count' => $download_info['new'],

      '@date' => $requested_date,

    );

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

    $total_count = $download_info['new'];

  }

  if ($total_count == 0) {

 *

 * @deprecated in webform:7.x-4.8 and is removed from webform:7.x-5.0. See

 * webform_results_download_rows_process().

 * @see https://www.drupal.org/project/webform/issues/2465291

    webform_update_webform_last_download($node, $GLOBALS['user']->uid, $export_info['last_sid'], REQUEST_TIME);

/**

 * Insert or update a download record in table {webform_last_download}.

 *

 * @param object $node

 *   The Webform node of the record to update.

 * @param int $uid

 *   The user ID of the record to update.

 * @param int $sid

 *   The last downloaded submission number.

 * @param int $requested

 *   Timestamp of last download request.

 *

 * @return int

 *   MergeQuery::STATUS_INSERT or ::STATUS_UPDATE.

 */

function webform_update_webform_last_download(stdClass $node, $uid, $sid, $requested) {

  return db_merge('webform_last_download')

    ->key(array(

      'nid' => $node->nid,

      'uid' => $uid,

    ))

    ->fields(array(

      'sid' => $sid,

      'requested' => $requested,

    ))

    ->execute();

}

  // Get a fresh copy of the node so that we are only saving these changes.

  // Otherwise, changes to the Webform on another tab will be overwritten.

  $node = node_load($node->nid, NULL, TRUE);

 * @param int $nid

 *   The node id of the webform.

 * @param array $range_options

 *   Associate array of range options.

 * @param int $uid

 *   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.

 *

 * @return array

 *   An array of submission IDs.

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

 *

 * @return int

 *   The number number of matching submissions.

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

    case 'new':

      // All since last download. This is the same as 'range_date' except that

      // the start date is the date of the last download.

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

      $start_date = (int) $download_info ? $download_info['requested'] : 0;

      $end_time = NULL;

      // Fall through.

      // If the submission is completed, use the completed date, otherwise, the

      // submitted date.

      $date_field = 'COALESCE(NULLIF(ws.completed, 0), ws.submitted)';

      // This is required because SQLite uses dynamic typing.

      if (db_driver() === 'sqlite') {

        $date_field = 'CAST(' . $date_field . ' AS INTEGER)';

      }

      if (!isset($start_date)) {

        $format = webform_date_format('short');

        $start_date = DateTime::createFromFormat($format, $range_options['start_date']);

        $start_date->setTime(0, 0, 0);

        $start_date = $start_date->getTimestamp();

        $end_time = DateTime::createFromFormat($format, $range_options['end_date']);

      }

      $query->where($date_field . ' >= :start_date', array(':start_date' => $start_date));

      if ($end_time) {

        $end_time = $end_time->getTimestamp();

        $query->where($date_field . ' <= :end_time', array(':end_time' => $end_time));