From d1edac845ce81f8ccf43a43803ab0a89574f285c Mon Sep 17 00:00:00 2001 From: Frederic Guillot Date: Sat, 11 Mar 2017 17:30:09 -0500 Subject: Change groups list layout --- app/Controller/GroupListController.php | 7 ++- app/Model/GroupModel.php | 8 ++- app/Template/group/dropdown.php | 9 +++ app/Template/group/index.php | 100 ++++++++++++++++++++------------- app/Template/group/users.php | 49 ++++++---------- 5 files changed, 96 insertions(+), 77 deletions(-) create mode 100644 app/Template/group/dropdown.php (limited to 'app') diff --git a/app/Controller/GroupListController.php b/app/Controller/GroupListController.php index 4486bbff..11081e4a 100644 --- a/app/Controller/GroupListController.php +++ b/app/Controller/GroupListController.php @@ -2,6 +2,9 @@ namespace Kanboard\Controller; +use Kanboard\Model\GroupModel; +use Kanboard\Model\UserModel; + /** * Group Controller * @@ -20,7 +23,7 @@ class GroupListController extends BaseController $paginator = $this->paginator ->setUrl('GroupListController', 'index') ->setMax(30) - ->setOrder('name') + ->setOrder(GroupModel::TABLE.'.name') ->setQuery($this->groupModel->getQuery()) ->calculate(); @@ -43,7 +46,7 @@ class GroupListController extends BaseController $paginator = $this->paginator ->setUrl('GroupListController', 'users', array('group_id' => $group_id)) ->setMax(30) - ->setOrder('username') + ->setOrder(UserModel::TABLE.'.username') ->setQuery($this->groupMemberModel->getQuery($group_id)) ->calculate(); diff --git a/app/Model/GroupModel.php b/app/Model/GroupModel.php index b43423b3..5acf7e3f 100644 --- a/app/Model/GroupModel.php +++ b/app/Model/GroupModel.php @@ -27,7 +27,9 @@ class GroupModel extends Base */ public function getQuery() { - return $this->db->table(self::TABLE); + return $this->db->table(self::TABLE) + ->columns('id', 'name', 'external_id') + ->subquery('SELECT COUNT(*) FROM '.GroupMemberModel::TABLE.' WHERE group_id='.self::TABLE.'.id', 'nb_users'); } /** @@ -39,7 +41,7 @@ class GroupModel extends Base */ public function getById($group_id) { - return $this->getQuery()->eq('id', $group_id)->findOne(); + return $this->db->table(self::TABLE)->eq('id', $group_id)->findOne(); } /** @@ -51,7 +53,7 @@ class GroupModel extends Base */ public function getByExternalId($external_id) { - return $this->getQuery()->eq('external_id', $external_id)->findOne(); + return $this->db->table(self::TABLE)->eq('external_id', $external_id)->findOne(); } /** diff --git a/app/Template/group/dropdown.php b/app/Template/group/dropdown.php new file mode 100644 index 00000000..9d807dc5 --- /dev/null +++ b/app/Template/group/dropdown.php @@ -0,0 +1,9 @@ + diff --git a/app/Template/group/index.php b/app/Template/group/index.php index 8370dc53..f85eab8b 100644 --- a/app/Template/group/index.php +++ b/app/Template/group/index.php @@ -1,42 +1,62 @@ -
-
+ + diff --git a/app/Template/group/users.php b/app/Template/group/users.php index 63cec338..5025ca7a 100644 --- a/app/Template/group/users.php +++ b/app/Template/group/users.php @@ -1,6 +1,7 @@
-- cgit v1.2.3