aboutsummaryrefslogtreecommitdiff
path: root/juick-server/src/main/java/com/juick/service/AdsServiceImpl.java
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2017-04-19 14:51:48 +0300
committerGravatar Vitaly Takmazov2017-05-05 12:06:28 +0300
commit045ca0848c8ee7c771541a5829157531c782cf30 (patch)
tree9a60049dae790fd01ace40d3757c0bfda74cd220 /juick-server/src/main/java/com/juick/service/AdsServiceImpl.java
parent9345af5e39695d191b221473ce3a51b03dc09db3 (diff)
juick-www: Home controller uses Pebble, drop ads
wip
Diffstat (limited to 'juick-server/src/main/java/com/juick/service/AdsServiceImpl.java')
-rw-r--r--juick-server/src/main/java/com/juick/service/AdsServiceImpl.java51
1 files changed, 0 insertions, 51 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
deleted file mode 100644
index f515e437..00000000
--- a/juick-server/src/main/java/com/juick/service/AdsServiceImpl.java
+++ /dev/null
@@ -1,51 +0,0 @@
-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
-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);
- }
-
- @Transactional
- @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);
- }
-}