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);
    }
}