function template_preprocess_webform_submission_navigation in Webform 7.4

Same name and namespace in other branches

1. 8.5 includes/webform.theme.template.inc \template_preprocess_webform_submission_navigation()
2. 6.3 includes/webform.submissions.inc \template_preprocess_webform_submission_navigation()
3. 7.3 includes/webform.submissions.inc \template_preprocess_webform_submission_navigation()
4. 6.x includes/webform.theme.template.inc \template_preprocess_webform_submission_navigation()

Preprocess function for webform-submission-navigation.tpl.php.

File

includes/webform.submissions.inc, line 1154

Submission handling functions.

Code

function template_preprocess_webform_submission_navigation(&$vars) {
  $start_path = $vars['mode'] == 'print' ? 'print/' : 'node/';
  $previous_query = db_select('webform_submissions')
    ->condition('nid', $vars['node']->nid)
    ->condition('sid', $vars['submission']->sid, '<');
  $previous_query
    ->addExpression('MAX(sid)');
  $next_query = db_select('webform_submissions')
    ->condition('nid', $vars['node']->nid)
    ->condition('sid', $vars['submission']->sid, '>');
  $next_query
    ->addExpression('MIN(sid)');
  $vars['previous'] = $previous_query
    ->execute()
    ->fetchField();
  $vars['next'] = $next_query
    ->execute()
    ->fetchField();
  $vars['previous_url'] = $start_path . $vars['node']->nid . '/submission/' . $vars['previous'] . ($vars['mode'] == 'form' ? '/edit' : '');
  $vars['next_url'] = $start_path . $vars['node']->nid . '/submission/' . $vars['next'] . ($vars['mode'] == 'form' ? '/edit' : '');
}