1 files changed, 51 insertions, 0 deletions
diff --git a/juick-server/src/main/java/com/juick/service/AdsServiceImpl.java b/juick-server/src/main/java/com/juick/service/AdsServiceImpl.java
new file mode 100644
index 00000000..a6a5c85d
--- /dev/null
+++ b/juick-server/src/main/java/com/juick/service/AdsServiceImpl.java
@@ -0,0 +1,51 @@
+package com.juick.service;
+
+import org.springframework.jdbc.core.JdbcTemplate;
+import org.springframework.stereotype.Repository;
+import org.springframework.transaction.PlatformTransactionManager;
+import org.springframework.transaction.annotation.Transactional;
+
+import javax.inject.Inject;
+import java.util.List;
+
+/**
+ * Created by aalexeev on 11/13/16.
+ */
+@Repository
+@Transactional
+public class AdsServiceImpl extends BaseJdbcService implements AdsService {
+
+    @Inject
+    public AdsServiceImpl(JdbcTemplate jdbcTemplate) {
+        super(jdbcTemplate, null);
+    }
+
+    @Transactional(readOnly = true)
+    @Override
+    public int getAdMid(final int uid) {
+        List<Integer> list;
+
+        if (uid > 0)
+            list = getJdbcTemplate().queryForList(
+                    "SELECT message_id FROM ads_messages " +
+                            "WHERE message_id NOT IN (SELECT message_id FROM ads_messages_log WHERE user_id = ? " +
+                            "AND ts > UNIX_TIMESTAMP() - 60*60*24 GROUP BY message_id HAVING COUNT(*) > 2) ORDER BY RAND() LIMIT 1",
+                    Integer.class,
+                    uid);
+
+        else
+            list = getJdbcTemplate().queryForList(
+                    "SELECT message_id FROM ads_messages ORDER BY RAND() LIMIT 1",
+                    Integer.class);
+
+        return list.isEmpty() ?
+                0 : list.get(0);
+    }
+
+    @Override
+    public int logAdMid(final int uid, final int mid) {
+        return getJdbcTemplate().update(
+                "INSERT INTO ads_messages_log(user_id, message_id, ts) VALUES (?, ?, UNIX_TIMESTAMP())",
+                uid, mid);
+    }
+}