summaryrefslogtreecommitdiff
path: root/app/Model/ProjectGroupRoleModel.php
diff options
context:
space:
mode:
authorFrederic Guillot <fred@kanboard.net>2017-06-03 16:53:40 -0400
committerFrederic Guillot <fred@kanboard.net>2017-06-03 16:53:40 -0400
commit9668723af4f9ad633d9c9131fbdceb47fa326d9e (patch)
tree86b019a77fa0ec05e77d10c5de16ee8fae697ade /app/Model/ProjectGroupRoleModel.php
parente27148dfd8192ed3052adb8397a0f8c4ed47916d (diff)
Add dropdown menu to autocomplete email field from project members
Diffstat (limited to 'app/Model/ProjectGroupRoleModel.php')
-rw-r--r--app/Model/ProjectGroupRoleModel.php8
1 files changed, 7 insertions, 1 deletions
diff --git a/app/Model/ProjectGroupRoleModel.php b/app/Model/ProjectGroupRoleModel.php
index 2729d5a6..2b1973f5 100644
--- a/app/Model/ProjectGroupRoleModel.php
+++ b/app/Model/ProjectGroupRoleModel.php
@@ -85,7 +85,13 @@ class ProjectGroupRoleModel extends Base
public function getUsers($project_id)
{
return $this->db->table(self::TABLE)
- ->columns(UserModel::TABLE.'.id', UserModel::TABLE.'.username', UserModel::TABLE.'.name', self::TABLE.'.role')
+ ->columns(
+ UserModel::TABLE.'.id',
+ UserModel::TABLE.'.username',
+ UserModel::TABLE.'.name',
+ UserModel::TABLE.'.email',
+ self::TABLE.'.role'
+ )
->join(GroupMemberModel::TABLE, 'group_id', 'group_id', self::TABLE)
->join(UserModel::TABLE, 'id', 'user_id', GroupMemberModel::TABLE)
->eq(self::TABLE.'.project_id', $project_id)