From ae16c7b66f8bfc74ef34eddc7d816172a91fe971 Mon Sep 17 00:00:00 2001 From: Killy Date: Wed, 27 Dec 2017 16:10:34 +0300 Subject: UserService - more stats --- .../src/main/java/com/juick/service/UserServiceImpl.java | 14 ++++++++++++++ 1 file changed, 14 insertions(+) (limited to 'juick-server-jdbc/src/main/java') diff --git a/juick-server-jdbc/src/main/java/com/juick/service/UserServiceImpl.java b/juick-server-jdbc/src/main/java/com/juick/service/UserServiceImpl.java index 9aa82559..d3f1c777 100644 --- a/juick-server-jdbc/src/main/java/com/juick/service/UserServiceImpl.java +++ b/juick-server-jdbc/src/main/java/com/juick/service/UserServiceImpl.java @@ -617,6 +617,20 @@ public class UserServiceImpl extends BaseJdbcService implements UserService { return list.isEmpty() ? 0 : list.get(0); } + @Transactional(readOnly = true) + @Override + public int getStatsPhotos(final int uid) { + List list = getJdbcTemplate().queryForList("SELECT COUNT(*) FROM messages WHERE user_id = ? AND attach IS NOT NULL", Integer.class, uid); + return list.isEmpty() ? 0 : list.get(0); + } + + @Transactional(readOnly = true) + @Override + public int getStatsFavorites(final int uid) { + List list = getJdbcTemplate().queryForList("SELECT COUNT(*) FROM favorites WHERE user_id = ?", Integer.class, uid); + return list.isEmpty() ? 0 : list.get(0); + } + @Transactional @Override public boolean setActiveStatusForJID(final String JID, final UserService.ActiveStatus jidStatus) { -- cgit v1.2.3