function support_substatus_load_client in Support Ticketing System 6

Load substatus assigned to a given client.

1 call to support_substatus_load_client()

support_substatus_form_alter in support_substatus/support_substatus.module

File

support_substatus/support_substatus.module, line 495

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_load_client($clid, $state = 0) {
  $substatus = array();
  if ($state) {
    $result = db_query('SELECT ss.ssid, ss.substatus FROM {support_substatus} ss LEFT JOIN {support_substatus_client} ssc ON ss.ssid = ssc.ssid LEFT JOIN {support_substatus_state} sss ON ss.ssid = sss.ssid WHERE (ssc.clid = %d OR ISNULL(ssc.clid)) AND stid = %d AND disabled = 0 ORDER BY ss.weight ASC', $clid, $state);
  }
  else {
    $result = db_query('SELECT ss.ssid, ss.substatus FROM {support_substatus} ss LEFT JOIN {support_substatus_client} ssc ON ss.ssid = ssc.ssid WHERE (ssc.clid = %d OR ISNULL(ssc.clid)) AND disabled = 0 ORDER BY ss.weight ASC', $clid);
  }
  while ($ss = db_fetch_object($result)) {
    $substatus[$ss->ssid] = $ss->substatus;
  }
  return $substatus;
}