Fix #6636 - add image icon to card
authorAlan Knowles <alan@roojs.com>
Wed, 10 Mar 2021 08:36:37 +0000 (16:36 +0800)
committerAlan Knowles <alan@roojs.com>
Wed, 10 Mar 2021 08:36:37 +0000 (16:36 +0800)
DataObjects/Mtrack_ticket.php

index d047fcb..2bd7871 100644 (file)
@@ -157,6 +157,21 @@ class Pman_MTrack_DataObjects_Mtrack_ticket extends DB_DataObject
              
             
         }
+        // is_deleted = 0...
+        $this->selectAdd("
+            COALESCE((
+                SELECT
+                    count(id)
+                FROM
+                    Images
+                WHERE
+                    onid = mtrack_ticket.id
+                    AND
+                    ontable = 'mtrack_ticket'
+                ), 0) as no_images
+            
+        ");
+        
         
         if ($au && isset($q['_options_for'])) {
             $this->optionsForProject($roo, $q['_options_for']);