function support_pm_query_support_timer_node_alter in Support Ticketing System 7
Alter the timer report for nodes to consider projects.
File
- support_pm/
support_pm.module, line 326 - Support Project Management. @author Jeremy Andrews <jeremy@tag1consulting.com> @package Support
Code
function support_pm_query_support_timer_node_alter($query) {
$project = isset($_GET['project']) ? $_GET['project'] : '';
if ($project && $project == preg_replace('/[^0-9a-zA-Z_-]/', '', $project)) {
$query
->leftJoin('support_project_ticket', 'spt', 'n.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);
}
}
}