blob: f515e437b31adb2950e56e2df4771154c056cf01 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
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
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);
}
}
|
