From ba5663d72a64eb47c106e40959913876d5a1904f Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Thu, 24 Dec 2020 12:59:40 +0800 Subject: [PATCH] sort is default asc, so 0 goes first --- DataObjects/Core_project.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/DataObjects/Core_project.php b/DataObjects/Core_project.php index 832410d..8ab8cd7 100644 --- a/DataObjects/Core_project.php +++ b/DataObjects/Core_project.php @@ -79,7 +79,7 @@ class Pman_MTrack_DataObjects_Core_project extends Pman_Core_DataObjects_Core_pr (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 + ),0) as no_tickets, IF (COALESCE(( SELECT count(mtrack_ticket.id) @@ -93,9 +93,9 @@ class Pman_MTrack_DataObjects_Core_project extends Pman_Core_DataObjects_Core_pr (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 + ),0) > 1, 0 , 0) as has_no_tickets "); - $this->_extra_cols = array('no_tickets','has_tickets'); + $this->_extra_cols = array('no_tickets','has_no_tickets'); } -- 2.39.2