sphinx search: page by offset

1 files changed, 4 insertions, 20 deletions

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)