summaryrefslogtreecommitdiff
path: root/app/Model/ProjectUserRoleModel.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/ProjectUserRoleModel.php
parente27148dfd8192ed3052adb8397a0f8c4ed47916d (diff)
Add dropdown menu to autocomplete email field from project members
Diffstat (limited to 'app/Model/ProjectUserRoleModel.php')
-rw-r--r--app/Model/ProjectUserRoleModel.php8
1 files changed, 7 insertions, 1 deletions
diff --git a/app/Model/ProjectUserRoleModel.php b/app/Model/ProjectUserRoleModel.php
index 76094431..a95cf5d9 100644
--- a/app/Model/ProjectUserRoleModel.php
+++ b/app/Model/ProjectUserRoleModel.php
@@ -98,7 +98,13 @@ class ProjectUserRoleModel 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(UserModel::TABLE, 'id', 'user_id')
->eq('project_id', $project_id)
->asc(UserModel::TABLE.'.username')