diff options
author | enahum <nahumhbl@gmail.com> | 2016-12-19 10:05:46 -0300 |
---|---|---|
committer | Joram Wilander <jwawilander@gmail.com> | 2016-12-19 08:05:46 -0500 |
commit | 999d1553e1ce45adf58f6082b160bc1147dc592b (patch) | |
tree | 369a9b7f46dd44d136a79a050469429169433cec /store/sql_team_store.go | |
parent | 3ce2ce9dc882ed962dc3ce7550bdb07963f376b6 (diff) | |
download | chat-999d1553e1ce45adf58f6082b160bc1147dc592b.tar.gz chat-999d1553e1ce45adf58f6082b160bc1147dc592b.tar.bz2 chat-999d1553e1ce45adf58f6082b160bc1147dc592b.zip |
PLT-4167 Team Sidebar (#4569)
* PLT-4167 Team Sidebar
* Address feedback from PM
* change route from my_members to members
* bug fixes
* Updating styles for teams sidebar (#4681)
* Added PM changes
* Fix corner cases
* Addressing feedback
* use two different endpoints
* Bug fixes
* Rename model and client functions, using preferences to store last team and channel viewed
* Fix mobile notification count and closing the team sidebar
* unit test, fixed bad merge and retrieve from cached when available
* bug fixes
* use id for last channel in preferences, query optimization
* Updating multi team css (#4830)
Diffstat (limited to 'store/sql_team_store.go')
-rw-r--r-- | store/sql_team_store.go | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/store/sql_team_store.go b/store/sql_team_store.go index 3ec336be5..13b6baa1a 100644 --- a/store/sql_team_store.go +++ b/store/sql_team_store.go @@ -583,6 +583,39 @@ func (s SqlTeamStore) GetTeamsForUser(userId string) StoreChannel { return storeChannel } +func (s SqlTeamStore) GetTeamsUnreadForUser(teamId, userId string) StoreChannel { + storeChannel := make(StoreChannel, 1) + + go func() { + result := StoreResult{} + + var members []*model.TeamUnread + _, err := s.GetReplica().Select(&members, + `SELECT + Channels.TeamId, + SUM(Channels.TotalMsgCount - ChannelMembers.MsgCount) as MsgCount, + SUM(ChannelMembers.MentionCount) as MentionCount + FROM + Channels, + ChannelMembers + WHERE + Channels.Id = ChannelMembers.ChannelId AND + ChannelMembers.UserId = :UserId AND Channels.TeamId != :TeamId + GROUP BY + Channels.TeamId`, map[string]interface{}{"UserId": userId, "TeamId": teamId}) + if err != nil { + result.Err = model.NewLocAppError("SqlTeamStore.GetTeamsUnreadForUser", "store.sql_team.get_unread.app_error", nil, "userId="+userId+" "+err.Error()) + } else { + result.Data = members + } + + storeChannel <- result + close(storeChannel) + }() + + return storeChannel +} + func (s SqlTeamStore) RemoveMember(teamId string, userId string) StoreChannel { storeChannel := make(StoreChannel, 1) |