sort has tickets

diff --git a/DataObjects/Core_project.php b/DataObjects/Core_project.php
index 3f2e615..832410d 100644 (file)
--- a/DataObjects/Core_project.php
+++ b/DataObjects/Core_project.php
@@ -63,7 +63,7 @@ class Pman_MTrack_DataObjects_Core_project extends Pman_Core_DataObjects_Core_pr
         
            
         }
-         
+          
         if (isset($q['_with_tickets'])) {
             $this->selectAdd("
                 COALESCE((
@@ -80,8 +80,22 @@ class Pman_MTrack_DataObjects_Core_project extends Pman_Core_DataObjects_Core_pr
                         AND
                         mtrack_ticket.project_id = core_project.id
                 ),0) as no_tickets
+                IF (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) > 0, 1 , 0) as has_tickets
             ");
-            
+            $this->_extra_cols = array('no_tickets','has_tickets');
         }