function quiz_views_handler_filter_user_quiz_state::query in Quiz 6.4

Same name and namespace in other branches

1. 8.4 includes/views/handlers/quiz_views_handler_filter_user_quiz_state.inc \quiz_views_handler_filter_user_quiz_state::query()
2. 6.6 includes/views/handlers/quiz_views_handler_filter_user_quiz_state.inc \quiz_views_handler_filter_user_quiz_state::query()
3. 6.3 includes/views/handlers/quiz_views_handler_filter_user_quiz_state.inc \quiz_views_handler_filter_user_quiz_state::query()
4. 6.5 includes/views/handlers/quiz_views_handler_filter_user_quiz_state.inc \quiz_views_handler_filter_user_quiz_state::query()
5. 7.6 includes/views/handlers/quiz_views_handler_filter_user_quiz_state.inc \quiz_views_handler_filter_user_quiz_state::query()
6. 7 includes/views/handlers/quiz_views_handler_filter_user_quiz_state.inc \quiz_views_handler_filter_user_quiz_state::query()
7. 7.4 includes/views/handlers/quiz_views_handler_filter_user_quiz_state.inc \quiz_views_handler_filter_user_quiz_state::query()

File

includes/views/handlers/quiz_views_handler_filter_user_quiz_state.inc, line 59

Class

quiz_views_handler_filter_user_quiz_state

Code

function query() {
  $val = is_array($this->value) ? $this->value['quiz_state'] : $this->value;
  if (empty($val) || $val == 'any') {
    return;
  }
  $this
    ->ensure_my_table();
  if ($val == 'not_started') {
    $this->query
      ->add_where(0, "{$this->table_alias}.time_end IS NULL");
  }
  else {
    $operator = $val == 'in_progress' ? '=' : '>';
    $this->query
      ->add_where(0, "{$this->table_alias}.time_end {$operator} 0");
  }
}