function _support_state_query_filter in Support Ticketing System 6

1 call to _support_state_query_filter()

_support_client_terms in ./support.module

Return an alphabetized list of all terms used with this client.

File

./support.module, line 3755

support.module

Code

function _support_state_query_filter($state) {
  if ($state == -2) {
    global $user;
    $query_filter = " AND st.assigned = {$user->uid} ";
  }
  else {
    $query_filter = '';
  }
  if ($state < 0) {
    $query_filter .= ' AND st.state NOT IN (' . implode(', ', _support_get_state(SUPPORT_STATE_CLOSED)) . ') ';
  }
  else {
    $query_filter .= $state ? " AND st.state = {$state} " : '';
  }
  return $query_filter;
}