diff options
| author | Dzial Techniczny WMW Projekt s.c <techniczna@wmwprojekt.pl> | 2019-12-10 11:34:53 +0100 |
|---|---|---|
| committer | Dzial Techniczny WMW Projekt s.c <techniczna@wmwprojekt.pl> | 2019-12-10 11:34:53 +0100 |
| commit | b8fa0246803dab40cf57d40b45984c53046f2d55 (patch) | |
| tree | dc92b167c7542137c385614a1d558e57669a4339 /plugins/Group_assign/Model/OldMetaMagikSubquery.php | |
| parent | 2a43146236fd8fb16f84398d85720ad84aa0a0b1 (diff) | |
Plugins directory and local modifications
Diffstat (limited to 'plugins/Group_assign/Model/OldMetaMagikSubquery.php')
| -rw-r--r-- | plugins/Group_assign/Model/OldMetaMagikSubquery.php | 28 |
1 files changed, 28 insertions, 0 deletions
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 |