From 7572edf59aae68c33a216534438acb407cc4325d Mon Sep 17 00:00:00 2001
From: CoRex <dev@corex.dk>
Date: Thu, 7 Dec 2017 20:03:14 +0100
Subject: Added 'model:subtask:count:query' to SubtaskModel.

---
 app/Model/SubtaskModel.php      | 15 ++++++++++++---
 doc/en_US/plugin-hooks.markdown |  1 +
 2 files changed, 13 insertions(+), 3 deletions(-)

diff --git a/app/Model/SubtaskModel.php b/app/Model/SubtaskModel.php
index 1e652ae2..626ccbef 100644
--- a/app/Model/SubtaskModel.php
+++ b/app/Model/SubtaskModel.php
@@ -88,13 +88,22 @@ class SubtaskModel extends Base
             ->asc(self::TABLE.'.position');
     }
 
+    /**
+     * Count by assignee and task status.
+     *
+     * @param integer $userId
+     * @return integer
+     */
     public function countByAssigneeAndTaskStatus($userId)
     {
-        return $this->db->table(self::TABLE)
+        $query = $this->db->table(self::TABLE)
             ->eq('user_id', $userId)
             ->eq(TaskModel::TABLE.'.is_active', TaskModel::STATUS_OPEN)
-            ->join(Taskmodel::TABLE, 'id', 'task_id')
-            ->count();
+            ->join(Taskmodel::TABLE, 'id', 'task_id');
+
+        $this->hook->reference('model:subtask:count:query', $query);
+
+        return $query->count();
     }
 
     /**
diff --git a/doc/en_US/plugin-hooks.markdown b/doc/en_US/plugin-hooks.markdown
index 54b9f689..09b8936b 100644
--- a/doc/en_US/plugin-hooks.markdown
+++ b/doc/en_US/plugin-hooks.markdown
@@ -144,6 +144,7 @@ List of reference hooks:
 | `model:color:get-list`                     | Alter default_colors values                                   |
 | `model:subtask:modification:prepare`       | Alter form values before to save a subtask                    |
 | `model:subtask:creation:prepare`           | Alter form values before to edit a subtask                    |
+| `model:subtask:count:query`                | Alter database query for subtask count                        |
 
 
 Template Hooks
-- 
cgit v1.2.3