From 6afdad578701d38dd45d7d1c8ef446269f3a1275 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Mon, 16 Jul 2018 15:53:38 +0300
Subject: sphinx search: page by offset

---
 .../com/juick/service/MessagesServiceImpl.java     | 24 ++++------------------
 1 file changed, 4 insertions(+), 20 deletions(-)

(limited to 'juick-server/src/main/java/com/juick/service/MessagesServiceImpl.java')

diff --git a/juick-server/src/main/java/com/juick/service/MessagesServiceImpl.java b/juick-server/src/main/java/com/juick/service/MessagesServiceImpl.java
index d64ecc04..a78c9203 100644
--- a/juick-server/src/main/java/com/juick/service/MessagesServiceImpl.java
+++ b/juick-server/src/main/java/com/juick/service/MessagesServiceImpl.java
@@ -628,15 +628,8 @@ public class MessagesServiceImpl extends BaseJdbcService implements MessagesServ
 
     @Transactional(readOnly = true)
     @Override
-    public List<Integer> getSearch(final String search, final int before) {
-        List<Integer> mids = searchService.searchInAllMessages(search, before);
-
-        if (!mids.isEmpty())
-            return getNamedParameterJdbcTemplate().queryForList(
-                    "SELECT message_id FROM messages WHERE message_id IN (:ids) AND privacy > 0 ORDER BY message_id DESC LIMIT 20",
-                    new MapSqlParameterSource("ids", mids),
-                    Integer.class);
-        return mids;
+    public List<Integer> getSearch(final String search, final int page) {
+        return searchService.searchInAllMessages(search, page);
     }
 
     @Transactional(readOnly = true)
@@ -755,17 +748,8 @@ public class MessagesServiceImpl extends BaseJdbcService implements MessagesServ
 
     @Transactional(readOnly = true)
     @Override
-    public List<Integer> getUserSearch(final int UID, final String search, final int privacy, final int before) {
-        List<Integer> mids = searchService.searchByStringAndUser(search, UID, before);
-
-        if (!mids.isEmpty()) {
-            return getNamedParameterJdbcTemplate().queryForList(
-                    "SELECT message_id FROM messages WHERE message_id IN (:ids) AND privacy >= :privacy ORDER BY message_id DESC",
-                    new MapSqlParameterSource("ids", mids)
-                            .addValue("privacy", privacy),
-                    Integer.class);
-        }
-        return mids;
+    public List<Integer> getUserSearch(final int UID, final String search, final int privacy, final int page) {
+        return searchService.searchByStringAndUser(search, UID, page);
     }
 
     @Transactional(readOnly = true)
-- 
cgit v1.2.3