From 09d0533511faee6ab2da2fd6db79eb0063fd429e Mon Sep 17 00:00:00 2001 From: Vitaly Takmazov Date: Tue, 23 Oct 2018 14:38:54 +0300 Subject: Do not use subscribed users jid --- .../main/java/com/juick/service/SubscriptionServiceImpl.java | 12 ------------ 1 file changed, 12 deletions(-) (limited to 'juick-server/src/main/java/com/juick/service/SubscriptionServiceImpl.java') diff --git a/juick-server/src/main/java/com/juick/service/SubscriptionServiceImpl.java b/juick-server/src/main/java/com/juick/service/SubscriptionServiceImpl.java index 2032576c..5ce3593b 100644 --- a/juick-server/src/main/java/com/juick/service/SubscriptionServiceImpl.java +++ b/juick-server/src/main/java/com/juick/service/SubscriptionServiceImpl.java @@ -51,18 +51,6 @@ public class SubscriptionServiceImpl extends BaseJdbcService implements Subscrip @Inject private TagService tagService; - @Transactional(readOnly = true) - @Override - public List getJIDSubscribedToUser(final int uid, final boolean friendsonly) { - return getNamedParameterJdbcTemplate().queryForList( - "SELECT jids.jid FROM subscr_users INNER JOIN jids " + - "ON (subscr_users.user_id = :uid AND subscr_users.suser_id = jids.user_id) WHERE jids.active = 1 " + - (friendsonly ? - " AND EXISTS (SELECT 1 FROM wl_users w WHERE w.user_id = :uid and jids.user_id = w.wl_user_id)" : StringUtils.EMPTY), - new MapSqlParameterSource("uid", uid), - String.class); - } - @Transactional(readOnly = true) @Override public List getSubscribedUsers(final int uid, final Message msg) { -- cgit v1.2.3