function support_pm_query_support_pager_alter in Support Ticketing System 7

Alter the ticket listing query to consider projects.

File

support_pm/support_pm.module, line 312

Support Project Management. @author Jeremy Andrews <jeremy@tag1consulting.com> @package Support

Code

function support_pm_query_support_pager_alter($query) {
  $client = $query
    ->getMetaData('support_client');
  if ($project = $client->parent == 0 ? arg(3) : arg(4)) {
    $project = db_query('SELECT p.projid FROM {support_project} p LEFT JOIN {support_project_client} c ON p.projid = c.projid WHERE (c.clid = :clid OR c.clid = 0) AND p.path = :path', array(
      ':clid' => $client->clid,
      ':path' => $project,
    ))
      ->fetchField();
    if ($project) {
      $query
        ->leftJoin('support_project_ticket', 'spt', 'n.nid = spt.nid');
      $query
        ->condition('spt.projid', $project);
    }
  }
}