From b8fa0246803dab40cf57d40b45984c53046f2d55 Mon Sep 17 00:00:00 2001
From: "Dzial Techniczny WMW Projekt s.c" <techniczna@wmwprojekt.pl>
Date: Tue, 10 Dec 2019 11:34:53 +0100
Subject: Plugins directory and local modifications

---
 .../Group_assign/Model/OldMetaMagikSubquery.php    | 28 ++++++++++++++++++++++
 1 file changed, 28 insertions(+)
 create mode 100644 plugins/Group_assign/Model/OldMetaMagikSubquery.php

(limited to 'plugins/Group_assign/Model/OldMetaMagikSubquery.php')

diff --git a/plugins/Group_assign/Model/OldMetaMagikSubquery.php b/plugins/Group_assign/Model/OldMetaMagikSubquery.php
new file mode 100644
index 00000000..787b7e4a
--- /dev/null
+++ b/plugins/Group_assign/Model/OldMetaMagikSubquery.php
@@ -0,0 +1,28 @@
+<?php
+
+namespace Kanboard\Plugin\Group_assign\Model;
+
+use Kanboard\Plugin\Group_assign\Model\OldTaskFinderModel;
+
+/**
+ * New Task Finder model
+ * Extends Group_assign Model
+ *
+ * @package  Kanboard\Plugin\Group_assign\Model
+ */
+class OldMetaMagikSubQuery extends OldTaskFinderModel
+{
+    const METADATA_TABLE = 'task_has_metadata';
+    /**
+     * Extended query
+     *
+     * @access public
+     * @return \PicoDb\Table
+     */
+    public function getExtendedQuery()
+    {
+        // add subquery to original Model, changing only what we want
+        return parent::getExtendedQuery()
+            ->subquery('(SELECT COUNT(*) FROM '.self::METADATA_TABLE.' WHERE task_id=tasks.id)', 'nb_metadata');
+    }
+}
\ No newline at end of file
-- 
cgit v1.3.1