function support_substatus_support_ticket_listing_filter_alter in Support Ticketing System 6

File

support_substatus/support_substatus.module, line 432

Support Substatus -- allows per-status sub-status values, so for example a "pending" ticket can be further marked with "needs review", etc. @author Jeremy Andrews <jeremy@tag1consulting.com> @package Support

Code

function support_substatus_support_ticket_listing_filter_alter(&$filters) {
  if (_support_substatus_client_active(_support_current_client())) {
    $ssid = isset($_GET['ssid']) ? $_GET['ssid'] : '';
    $unsanitized = explode(',', $ssid);
    foreach ($unsanitized as $element) {
      $element = (int) $element;
      if ($element) {
        $filters['ssid'][$element] = $element;
      }
    }
    if (isset($filters['ssid']) && !empty($filters['ssid'])) {
      $filters['join'][] = 'LEFT JOIN {support_substatus_ticket} sst ON t.nid = sst.nid';
      $filters['where'][] = strtr('sst.subid IN (!ssid) AND sst.current = 1', array(
        '!ssid' => implode(',', $filters['ssid']),
      ));
    }
  }
}