summaryrefslogtreecommitdiff
path: root/app/Model/Task.php
diff options
context:
space:
mode:
authorFrédéric Guillot <fred@kanboard.net>2014-08-16 17:53:07 -0700
committerFrédéric Guillot <fred@kanboard.net>2014-08-16 17:53:07 -0700
commit658123a2328867a87da59ca660a7044d99eea22c (patch)
treee9d278eeba1699b13823dc7b115dce56635d0823 /app/Model/Task.php
parentdb3c006be80d6690892b11608619f9683824e21b (diff)
The fullname is displayed instead of the username if not empty
Diffstat (limited to 'app/Model/Task.php')
-rw-r--r--app/Model/Task.php7
1 files changed, 5 insertions, 2 deletions
diff --git a/app/Model/Task.php b/app/Model/Task.php
index 6647f041..0753c57d 100644
--- a/app/Model/Task.php
+++ b/app/Model/Task.php
@@ -125,7 +125,9 @@ class Task extends Base
projects.name AS project_name,
columns.title AS column_title,
users.username AS assignee_username,
- creators.username AS creator_username
+ users.name AS assignee_name,
+ creators.username AS creator_username,
+ creators.name AS creator_name
FROM tasks
LEFT JOIN users ON users.id = tasks.owner_id
LEFT JOIN users AS creators ON creators.id = tasks.creator_id
@@ -209,7 +211,8 @@ class Task extends Base
'tasks.is_active',
'tasks.score',
'tasks.category_id',
- 'users.username'
+ 'users.username AS assignee_username',
+ 'users.name AS assignee_name'
)
->join(User::TABLE, 'id', 'owner_id');