Uncommited changes synced

[Pman.MTrack] / DataObjects / Core_project.php

diff --git a/DataObjects/Core_project.php b/DataObjects/Core_project.php
index 702d578..3f2e615 100644 (file)
--- a/DataObjects/Core_project.php
+++ b/DataObjects/Core_project.php
@@ -63,6 +63,27 @@ class Pman_MTrack_DataObjects_Core_project extends Pman_Core_DataObjects_Core_pr
         
            
         }
+         
+        if (isset($q['_with_tickets'])) {
+            $this->selectAdd("
+                COALESCE((
+                    SELECT
+                        count(mtrack_ticket.id)
+                    FROM
+                        mtrack_ticket
+                    LEFT JOIN
+                       core_enum as join_status_id
+                    ON
+                        join_status_id.id = mtrack_ticket.status
+                    WHERE
+                        (join_status_id.name NOT IN('closed', 'on hold') OR  mtrack_ticket.status  = 0)
+                        AND
+                        mtrack_ticket.project_id = core_project.id
+                ),0) as no_tickets
+            ");
+            
+        }
+        
         
         if (isset($q['_mtrack_repos_only'])) { 
         //?/ should we hide closed projects by default even from admin?