casetracker_views_handler_filter_case.inc in Case Tracker 7

File

includes/casetracker_views_handler_filter_case.inc

<?php

/**
 * Filter to only show casetracker cases.
 */
class casetracker_views_handler_filter_case extends views_handler_filter {
  function query() {
    $case_types = array_filter(variable_get('casetracker_case_node_types', array(
      'casetracker_basic_case',
    )));
    if (!empty($case_types)) {

      //$placeholders = db_placeholders($case_types, 'varchar');
      $placeholders = $this
        ->placeholder();
      $table = $this->query
        ->ensure_table('node');

      //$this->query->add_where($this->options['group'], "$table.type IN ($placeholders)", $case_types);
      $this->query
        ->add_where_expression($this->options['group'], "{$table}.type IN ({$placeholders})", array(
        $placeholders => $case_types,
      ));
    }
    else {
      $this->query
        ->add_where($this->options['group'], "FALSE");
      $msg = t('You have no node types which are acting as cases.');
      if (user_access('administer case tracker')) {
        $msg .= ' ' . l(t('Configure case tracker.'), 'admin/config/casetracker');
      }
      drupal_set_message($msg, 'warning');
    }
  }

}

Classes

Name	Description
casetracker_views_handler_filter_case	Filter to only show casetracker cases.