VisitLogService.java 5.18 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.community.api.enums.DeleteTagEnum;
刘基明's avatar
刘基明 committed
5
import com.tanpu.community.api.enums.VisitTypeEnum;
刘基明's avatar
刘基明 committed
6
import com.tanpu.community.dao.entity.community.TimesCountEntity;
刘基明's avatar
刘基明 committed
7 8
import com.tanpu.community.dao.entity.community.VisitLogEntity;
import com.tanpu.community.dao.mapper.community.VisitLogMapper;
张辰's avatar
张辰 committed
9
import lombok.extern.slf4j.Slf4j;
刘基明's avatar
刘基明 committed
10
import org.apache.commons.collections4.CollectionUtils;
张辰's avatar
张辰 committed
11
import org.apache.commons.collections4.ListUtils;
张辰's avatar
张辰 committed
12
import org.apache.commons.lang3.time.DateUtils;
张辰's avatar
张辰 committed
13
import org.springframework.stereotype.Service;
刘基明's avatar
刘基明 committed
14
import org.springframework.transaction.annotation.Transactional;
张辰's avatar
张辰 committed
15 16

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

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

    @Resource
刘基明's avatar
刘基明 committed
29
    private VisitLogMapper visitLogMapper;
张辰's avatar
张辰 committed
30

张辰's avatar
张辰 committed
31 32 33 34
    // 获取用户7天内访问过的
    public List<String> queryUserRecentVisited(String userId) {
        Date endDate = new Date();
        Date startDate = DateUtils.addDays(endDate, -7);
刘基明's avatar
刘基明 committed
35
        List<String> visited = visitLogMapper.selectRefIdByUserIdAndCreateBetween(userId, startDate, endDate);
张辰's avatar
张辰 committed
36 37 38
        return visited;
    }

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

张辰's avatar
张辰 committed
57 58

    @Transactional
刘基明's avatar
刘基明 committed
59 60 61
    public void insertOrUpdateDur(VisitLogEntity vs) {
        if (visitLogMapper.selectByIdent(vs.getIdent()) == null) {
            visitLogMapper.insert(vs);
张辰's avatar
张辰 committed
62
        } else {
刘基明's avatar
刘基明 committed
63
            visitLogMapper.updateDurByIdent(vs.getDuration(), vs.getIdent());
张辰's avatar
张辰 committed
64 65 66
        }
    }

刘基明's avatar
刘基明 committed
67 68 69
    @Transactional
    //TODO 临时埋点,接入新埋点后删除
    public void addPageView(String userId, String targetId, VisitTypeEnum type) {
刘基明's avatar
刘基明 committed
70
        visitLogMapper.insert(VisitLogEntity.builder()
刘基明's avatar
刘基明 committed
71 72 73 74 75 76 77
                .visitorId(userId)
                .refId(targetId)
                .refType(type.getCode())
                .duration(0)
                .build());
    }

张辰's avatar
张辰 committed
78 79
    // 查询话题 详细页面 浏览量
    public Integer queryTopicDetailVisit(String topicId) {
刘基明's avatar
刘基明 committed
80 81 82
        return visitLogMapper.selectCount(new LambdaQueryWrapper<VisitLogEntity>()
                .eq(VisitLogEntity::getRefId, topicId)
                .eq(VisitLogEntity::getRefType, VisitTypeEnum.TOPIC_PAGE_VIEW.getCode()));
刘基明's avatar
刘基明 committed
83 84 85 86
    }

    // 查询主题 浏览量
    public Integer queryThemeVisit(String theme) {
刘基明's avatar
刘基明 committed
87 88 89
        return visitLogMapper.selectCount(new LambdaQueryWrapper<VisitLogEntity>()
                .eq(VisitLogEntity::getRefId, theme)
                .eq(VisitLogEntity::getRefType, VisitTypeEnum.THEME_PAGE_VIEW.getCode()));
刘基明's avatar
刘基明 committed
90 91 92 93
    }

    // 查询主题 浏览量
    public Integer queryThemeVisit(List<String> themes) {
刘基明's avatar
刘基明 committed
94 95 96
        if (CollectionUtils.isEmpty(themes)){
            return 0;
        }
刘基明's avatar
刘基明 committed
97 98 99
        return visitLogMapper.selectCount(new LambdaQueryWrapper<VisitLogEntity>()
                .in(VisitLogEntity::getRefId, themes)
                .eq(VisitLogEntity::getRefType, VisitTypeEnum.THEME_PAGE_VIEW.getCode()));
张辰's avatar
张辰 committed
100
    }
张辰's avatar
张辰 committed
101

刘基明's avatar
刘基明 committed
102
    public LocalDateTime queryLatestViewFollow(String userId) {
刘基明's avatar
刘基明 committed
103 104 105 106
        List<VisitLogEntity> visitSummaryEntities = visitLogMapper.selectList(new LambdaQueryWrapper<VisitLogEntity>()
                .eq(VisitLogEntity::getVisitorId, userId)
                .eq(VisitLogEntity::getRefType, VisitTypeEnum.FOLLOW_THEME_VIEW.getCode())
                .orderByDesc(VisitLogEntity::getCreateTime));
刘基明's avatar
刘基明 committed
107 108 109 110 111 112
        if (CollectionUtils.isEmpty(visitSummaryEntities)) {
            return null;
        } else {
            return visitSummaryEntities.get(0).getCreateTime();
        }
    }
刘基明's avatar
刘基明 committed
113

刘基明's avatar
刘基明 committed
114
    //统计行为集合的浏览量
刘基明's avatar
刘基明 committed
115 116 117 118
    public Map<String, Integer> getCountMapByTargetIds(List<String> refIds, VisitTypeEnum type) {
        if (CollectionUtils.isEmpty(refIds)){
            return new HashMap<>();
        }
刘基明's avatar
刘基明 committed
119 120 121 122 123 124
        LambdaQueryWrapper<VisitLogEntity> wrapper = (new LambdaQueryWrapper<VisitLogEntity>()
                .in(VisitLogEntity::getRefId,refIds))
                .eq(VisitLogEntity::getDeleteTag, DeleteTagEnum.NOT_DELETED)
                .eq(VisitLogEntity::getRefType,type.getCode())
                .groupBy(VisitLogEntity::getRefId);
        return visitLogMapper.selectCountByThemeIds(wrapper).stream()
刘基明's avatar
刘基明 committed
125 126
                .collect(Collectors.toMap(TimesCountEntity::getId, TimesCountEntity::getTimes));
    }
张辰's avatar
张辰 committed
127
}