VisitLogService.java 6.59 KB
Newer Older
张辰's avatar
张辰 committed
1 2 3
package com.tanpu.community.service;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
张辰's avatar
张辰 committed
4
import com.tanpu.biz.common.enums.clue.PageEnum;
刘基明's avatar
刘基明 committed
5
import com.tanpu.community.api.enums.DeleteTagEnum;
刘基明's avatar
刘基明 committed
6
import com.tanpu.community.cache.RedisCache;
刘基明's avatar
刘基明 committed
7
import com.tanpu.community.dao.entity.community.TimesCountEntity;
刘基明's avatar
刘基明 committed
8 9
import com.tanpu.community.dao.entity.community.VisitLogEntity;
import com.tanpu.community.dao.mapper.community.VisitLogMapper;
张辰's avatar
张辰 committed
10
import lombok.extern.slf4j.Slf4j;
刘基明's avatar
刘基明 committed
11
import org.apache.commons.collections4.CollectionUtils;
张辰's avatar
张辰 committed
12
import org.apache.commons.collections4.ListUtils;
刘基明's avatar
刘基明 committed
13
import org.apache.commons.lang3.StringUtils;
张辰's avatar
张辰 committed
14
import org.apache.commons.lang3.time.DateUtils;
张辰's avatar
张辰 committed
15
import org.springframework.stereotype.Service;
刘基明's avatar
刘基明 committed
16
import org.springframework.transaction.annotation.Transactional;
张辰's avatar
张辰 committed
17 18

import javax.annotation.Resource;
张辰's avatar
张辰 committed
19
import java.util.Date;
刘基明's avatar
刘基明 committed
20
import java.util.HashMap;
刘基明's avatar
刘基明 committed
21
import java.util.List;
刘基明's avatar
刘基明 committed
22
import java.util.Map;
张辰's avatar
张辰 committed
23
import java.util.stream.Collectors;
张辰's avatar
张辰 committed
24

25 26
import static com.tanpu.biz.common.enums.clue.PageEnum.COMM_VISIT_TOPIC_DETAIL;

张辰's avatar
张辰 committed
27 28
@Slf4j
@Service
刘基明's avatar
刘基明 committed
29
public class VisitLogService {
张辰's avatar
张辰 committed
30 31

    @Resource
刘基明's avatar
刘基明 committed
32
    private VisitLogMapper visitLogMapper;
张辰's avatar
张辰 committed
33

刘基明's avatar
刘基明 committed
34 35 36
    @Resource
    private RedisCache redisCache;

张辰's avatar
张辰 committed
37 38 39 40
    // 获取用户7天内访问过的
    public List<String> queryUserRecentVisited(String userId) {
        Date endDate = new Date();
        Date startDate = DateUtils.addDays(endDate, -7);
张辰's avatar
张辰 committed
41
        List<String> visited = visitLogMapper.selectRefIdByVisitorIdAndCreateBetween(userId, startDate, endDate);
张辰's avatar
张辰 committed
42 43 44
        return visited;
    }

45
    // 从refIds中去掉用户已经访问过的
张辰's avatar
张辰 committed
46 47 48 49
    public List<String> filterUserNotVisited(String userId, List<String> refIds) {
        if (refIds.isEmpty()) {
            return refIds;
        }
刘基明's avatar
刘基明 committed
50 51 52 53
        List<String> visited = visitLogMapper.selectList(new LambdaQueryWrapper<VisitLogEntity>()
                .eq(VisitLogEntity::getVisitorId, userId)
                .in(VisitLogEntity::getRefId, refIds))
                .stream().map(VisitLogEntity::getRefId).distinct().collect(Collectors.toList());
张辰's avatar
张辰 committed
54 55
        return ListUtils.subtract(refIds, visited);
    }
刘基明's avatar
刘基明 committed
56

刘基明's avatar
刘基明 committed
57
    public List<String> queryUserVisited(String userId) {
刘基明's avatar
刘基明 committed
58 59 60
        List<String> visited = visitLogMapper.selectList(new LambdaQueryWrapper<VisitLogEntity>()
                .eq(VisitLogEntity::getVisitorId, userId))
                .stream().map(VisitLogEntity::getRefId).distinct().collect(Collectors.toList());
刘基明's avatar
刘基明 committed
61 62 63
        return visited;
    }

张辰's avatar
张辰 committed
64 65

    @Transactional
刘基明's avatar
刘基明 committed
66
    public void insertOrUpdateDur(VisitLogEntity vs) {
刘基明's avatar
刘基明 committed
67
        // 分布式锁
刘基明's avatar
刘基明 committed
68
        for (int i = 0; i < 5 * 10; i++) {
刘基明's avatar
刘基明 committed
69
            String key = getVisitLogRedisKey(vs);
刘基明's avatar
刘基明 committed
70 71
            String rand = String.valueOf((int) Math.floor(Math.random() * 100));
            if (redisCache.setIfAbsent(key, rand, 15)) {
刘基明's avatar
刘基明 committed
72 73 74
                if (visitLogMapper.selectByIdentAndRefId(vs.getIdent(), vs.getRefId(), vs.getRefType()) == null) {
                    visitLogMapper.insert(vs);
                } else {
刘基明's avatar
刘基明 committed
75
                    visitLogMapper.updateDurByIdent(vs.getDuration(), vs.getIdent(), vs.getRefId(), vs.getRefType());
刘基明's avatar
刘基明 committed
76
                }
刘基明's avatar
刘基明 committed
77
                redisCache.evict(key + ":" + rand);
刘基明's avatar
刘基明 committed
78 79
                return;
            }
刘基明's avatar
刘基明 committed
80 81 82 83 84
            try {
                Thread.sleep(200);
            } catch (InterruptedException e) {
                e.printStackTrace();
            }
张辰's avatar
张辰 committed
85 86 87
        }
    }

刘基明's avatar
刘基明 committed
88 89 90 91
    private String getVisitLogRedisKey(VisitLogEntity vs) {
        return StringUtils.join("insertOrUpdateDur:", vs.getIdent().substring(0, 4), vs.getRefId(), vs.getRefType());
    }

刘基明's avatar
刘基明 committed
92 93
    @Transactional
    //TODO 临时埋点,接入新埋点后删除
94
    public void addPageView(String userId, String targetId, PageEnum type) {
刘基明's avatar
刘基明 committed
95
        visitLogMapper.insert(VisitLogEntity.builder()
刘基明's avatar
刘基明 committed
96 97
                .visitorId(userId)
                .refId(targetId)
98
                .refType(type.getId())
刘基明's avatar
刘基明 committed
99 100 101 102
                .duration(0)
                .build());
    }

张辰's avatar
张辰 committed
103 104
    // 查询话题 详细页面 浏览量
    public Integer queryTopicDetailVisit(String topicId) {
刘基明's avatar
刘基明 committed
105 106
        return visitLogMapper.selectCount(new LambdaQueryWrapper<VisitLogEntity>()
                .eq(VisitLogEntity::getRefId, topicId)
107
                .eq(VisitLogEntity::getRefType, COMM_VISIT_TOPIC_DETAIL.getId()));
刘基明's avatar
刘基明 committed
108 109 110 111
    }

    // 查询主题 浏览量
    public Integer queryThemeVisit(String theme) {
刘基明's avatar
刘基明 committed
112 113
        return visitLogMapper.selectCount(new LambdaQueryWrapper<VisitLogEntity>()
                .eq(VisitLogEntity::getRefId, theme)
张辰's avatar
张辰 committed
114
                .eq(VisitLogEntity::getRefType, PageEnum.COMM_VISIT_THEME.getId()));
刘基明's avatar
刘基明 committed
115 116 117 118
    }

    // 查询主题 浏览量
    public Integer queryThemeVisit(List<String> themes) {
刘基明's avatar
刘基明 committed
119
        if (CollectionUtils.isEmpty(themes)) {
刘基明's avatar
刘基明 committed
120 121
            return 0;
        }
刘基明's avatar
刘基明 committed
122 123
        return visitLogMapper.selectCount(new LambdaQueryWrapper<VisitLogEntity>()
                .in(VisitLogEntity::getRefId, themes)
张辰's avatar
张辰 committed
124
                .eq(VisitLogEntity::getRefType, PageEnum.COMM_VISIT_THEME.getId()));
张辰's avatar
张辰 committed
125
    }
张辰's avatar
张辰 committed
126

刘基明's avatar
刘基明 committed
127

刘基明's avatar
刘基明 committed
128
    //统计行为集合的浏览量
张辰's avatar
张辰 committed
129
    public Map<String, Integer> getCountMapByTargetIds(List<String> refIds, String refType) {
刘基明's avatar
刘基明 committed
130
        if (CollectionUtils.isEmpty(refIds)) {
刘基明's avatar
刘基明 committed
131 132
            return new HashMap<>();
        }
刘基明's avatar
刘基明 committed
133
        LambdaQueryWrapper<VisitLogEntity> wrapper = (new LambdaQueryWrapper<VisitLogEntity>()
刘基明's avatar
刘基明 committed
134
                .in(VisitLogEntity::getRefId, refIds))
刘基明's avatar
刘基明 committed
135
                .eq(VisitLogEntity::getDeleteTag, DeleteTagEnum.NOT_DELETED)
张辰's avatar
张辰 committed
136
                .eq(VisitLogEntity::getRefType, refType)
刘基明's avatar
刘基明 committed
137 138
                .groupBy(VisitLogEntity::getRefId);
        return visitLogMapper.selectCountByThemeIds(wrapper).stream()
刘基明's avatar
刘基明 committed
139 140
                .collect(Collectors.toMap(TimesCountEntity::getId, TimesCountEntity::getTimes));
    }
刘基明's avatar
刘基明 committed
141

刘基明's avatar
刘基明 committed
142 143 144 145 146 147 148 149 150 151 152 153 154 155
    //统计行为集合的浏览量
    public Map<String, Integer> getCountMapByTargetIds(List<String> refIds, List<String> refTypes) {
        if (CollectionUtils.isEmpty(refIds)) {
            return new HashMap<>();
        }
        LambdaQueryWrapper<VisitLogEntity> wrapper = (new LambdaQueryWrapper<VisitLogEntity>()
                .in(VisitLogEntity::getRefId, refIds))
                .eq(VisitLogEntity::getDeleteTag, DeleteTagEnum.NOT_DELETED)
                .in(VisitLogEntity::getRefType, refTypes)
                .groupBy(VisitLogEntity::getRefId);
        return visitLogMapper.selectCountByThemeIds(wrapper).stream()
                .collect(Collectors.toMap(TimesCountEntity::getId, TimesCountEntity::getTimes));
    }

刘基明's avatar
刘基明 committed
156 157 158 159 160 161 162 163
    // 查询讨论区最近浏览
    public Integer queryLastTopicVisit(String theme) {
        return visitLogMapper.selectCount(new LambdaQueryWrapper<VisitLogEntity>()
                .eq(VisitLogEntity::getRefId, theme)
                .eq(VisitLogEntity::getRefType, PageEnum.COMM_VISIT_THEME.getId()));
    }


张辰's avatar
张辰 committed
164
}