function _quiz_get_duration_intervals in Quiz 8.4

Same name and namespace in other branches

1. 6.4 quiz.admin.inc \_quiz_get_duration_intervals()
2. 7 quiz.admin.inc \_quiz_get_duration_intervals()
3. 7.4 quiz.admin.inc \_quiz_get_duration_intervals()

Returns an array with sql where clauses correscponding to the options in the duration filters.

Return value

$changed_timestamps array of timestamps and sql filters

See also

_quiz_questions_browser_form()

1 call to _quiz_get_duration_intervals()

_quiz_results_mr_prepare_filter in ./quiz.admin.inc

Returns sql and parameters to be added in join, where and group clauses in the _quiz_results_mr_data_provider select statement

File

./quiz.admin.inc, line 2413

Administrator interface for Quiz module.

Code

function _quiz_get_duration_intervals() {

  // Create datastructure to help create where clause in the sql for the changed filter...
  $durations = array(
    NULL,
    '> 60',
    '> 300',
    '> 600',
    '> 3600',
    '> 28800',
    '> 86400',
    '< 60',
    '< 300',
    '< 600',
    '< 3600',
    '< 28800',
    '< 86400',
  );
  foreach ($durations as $key => &$val) {
    if ($val == NULL) {
      continue;
    }
    $durations[$key] = ' AND (time_end - time_start) ' . $val;
  }
  return $durations;
}