DataObjects/Mtrack_ticket.php
authorAlan Knowles <alan@roojs.com>
Thu, 24 Dec 2020 05:49:26 +0000 (13:49 +0800)
committerAlan Knowles <alan@roojs.com>
Thu, 24 Dec 2020 05:49:26 +0000 (13:49 +0800)
DataObjects/Mtrack_ticket.php

index e3f9173..59fd718 100644 (file)
@@ -357,7 +357,9 @@ class Pman_MTrack_DataObjects_Mtrack_ticket extends DB_DataObject
                 IF( etype='ticketstate'
                     AND name='assigned' , 10, 0) +
                 IF( etype='ticketstate' AND
-                        name !='closed'  AND  name != 'new' , 100, 0) +
+                        name !='closed'  AND  name != 'new'
+                        AND
+                        name !='CLOSED'  AND  name != 'NEW', 100, 0) +
                 IF( etype='ticketstate' , 0 , 1000) +
 
                 seqid
@@ -376,6 +378,8 @@ class Pman_MTrack_DataObjects_Mtrack_ticket extends DB_DataObject
                         ( CONCAT(etype , '.', name) != 'ticketstate.closed')
                         AND
                          ( CONCAT(etype , '.', name) != 'ticketstate.reopened')
+                         AND 
+                         ( CONCAT(etype , '.', name) != 'ticketstate.CLOSED') 
                     ");
                     break;