function support_pm_query_support_timer_comment_alter in Support Ticketing System 7

Alter the timer report for comments to consider projects.

File

support_pm/support_pm.module, line 343

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

Code

function support_pm_query_support_timer_comment_alter($query) {
  $project = isset($_GET['project']) ? $_GET['project'] : '';
  if ($project && $project == preg_replace('/[^0-9a-zA-Z_-]/', '', $project)) {
    $query
      ->leftJoin('support_project_ticket', 'spt', 'c.nid = spt.nid');
    $query
      ->leftJoin('support_project', 'sp', 'spt.projid = sp.projid');
    if (strtolower($project) == 'null') {
      $query
        ->isNull('sp.path');
    }
    else {
      $query
        ->condition('sp.path', $project);
    }
  }
}