diff options
author | Vitaly Takmazov | 2024-04-26 18:33:58 +0300 |
---|---|---|
committer | Vitaly Takmazov | 2024-04-26 18:33:58 +0300 |
commit | e00dc41afada45c9cc0cab882d5e67f8d0c980f2 (patch) | |
tree | daf9e4f9de024f51dc3a581f38bf1d34986ce74f /src/main/java/com/juick/service/MessagesServiceImpl.java | |
parent | 57fae6b2d4e2f94e49a3b809a47ef4abc2a1ef80 (diff) |
"Mark read" buttonmark_read
Diffstat (limited to 'src/main/java/com/juick/service/MessagesServiceImpl.java')
-rw-r--r-- | src/main/java/com/juick/service/MessagesServiceImpl.java | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/src/main/java/com/juick/service/MessagesServiceImpl.java b/src/main/java/com/juick/service/MessagesServiceImpl.java index 940cdaba..105b86cf 100644 --- a/src/main/java/com/juick/service/MessagesServiceImpl.java +++ b/src/main/java/com/juick/service/MessagesServiceImpl.java @@ -1084,6 +1084,15 @@ public class MessagesServiceImpl extends BaseJdbcService implements MessagesServ rid, mid, user.getUid()); } + @Override + public void setAllRead(User user) { + jdbcTemplate.update(""" + update subscr_messages set last_read_rid=total.replies FROM messages + INNER JOIN messages total on total.message_id=messages.message_id + WHERE messages.message_id=subscr_messages.message_id AND subscr_messages.suser_id=? + """, user.getUid()); + } + @Transactional @Override public void setRead(User user, Integer mid) { |