VisitSummaryService.java 5.36 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 9
import com.tanpu.community.dao.entity.community.VisitSummaryEntity;
import com.tanpu.community.dao.mapper.community.VisitSummaryMapper;
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 26 27 28 29 30

@Slf4j
@Service
public class VisitSummaryService {

    @Resource
    private VisitSummaryMapper visitSummaryMapper;

张辰's avatar
张辰 committed
31 32 33 34 35 36 37 38
    // 获取用户7天内访问过的
    public List<String> queryUserRecentVisited(String userId) {
        Date endDate = new Date();
        Date startDate = DateUtils.addDays(endDate, -7);
        List<String> visited = visitSummaryMapper.selectRefIdByUserIdAndCreateBetween(userId, startDate, endDate);
        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 = visitSummaryMapper.selectList(new LambdaQueryWrapper<VisitSummaryEntity>()
                .eq(VisitSummaryEntity::getVisitorId, userId)
                .in(VisitSummaryEntity::getRefId, refIds))
                .stream().map(VisitSummaryEntity::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 54 55 56
        List<String> visited = visitSummaryMapper.selectList(new LambdaQueryWrapper<VisitSummaryEntity>()
                .eq(VisitSummaryEntity::getVisitorId, userId))
                .stream().map(VisitSummaryEntity::getRefId).distinct().collect(Collectors.toList());
        return visited;
    }

张辰's avatar
张辰 committed
57 58 59 60 61 62 63 64 65 66

    @Transactional
    public void insertOrUpdateDur(VisitSummaryEntity vs) {
        if (visitSummaryMapper.selectByIdent(vs.getIdent()) == null) {
            visitSummaryMapper.insert(vs);
        } else {
            visitSummaryMapper.updateDurByIdent(vs.getDuration(), vs.getIdent());
        }
    }

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

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

    // 查询主题 浏览量
    public Integer queryThemeVisit(String theme) {
        return visitSummaryMapper.selectCount(new LambdaQueryWrapper<VisitSummaryEntity>()
                .eq(VisitSummaryEntity::getRefId, theme)
刘基明's avatar
刘基明 committed
89
                .eq(VisitSummaryEntity::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
        return visitSummaryMapper.selectCount(new LambdaQueryWrapper<VisitSummaryEntity>()
                .in(VisitSummaryEntity::getRefId, themes)
刘基明's avatar
刘基明 committed
99
                .eq(VisitSummaryEntity::getRefType, VisitTypeEnum.THEME_PAGE_VIEW.getCode()));
张辰's avatar
张辰 committed
100
    }
张辰's avatar
张辰 committed
101

刘基明's avatar
刘基明 committed
102 103 104 105 106 107 108 109 110 111 112
    public LocalDateTime queryLatestViewFollow(String userId) {
        List<VisitSummaryEntity> visitSummaryEntities = visitSummaryMapper.selectList(new LambdaQueryWrapper<VisitSummaryEntity>()
                .eq(VisitSummaryEntity::getVisitorId, userId)
                .eq(VisitSummaryEntity::getRefType, VisitTypeEnum.FOLLOW_THEME_VIEW.getCode())
                .orderByDesc(VisitSummaryEntity::getCreateTime));
        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
        LambdaQueryWrapper<VisitSummaryEntity> wrapper = (new LambdaQueryWrapper<VisitSummaryEntity>()
刘基明's avatar
刘基明 committed
120
                .in(VisitSummaryEntity::getRefId,refIds))
刘基明's avatar
刘基明 committed
121 122 123 124 125 126
                .eq(VisitSummaryEntity::getDeleteTag, DeleteTagEnum.NOT_DELETED)
                .eq(VisitSummaryEntity::getRefType,type.getCode())
                .groupBy(VisitSummaryEntity::getRefId);
        return visitSummaryMapper.selectCountByThemeIds(wrapper).stream()
                .collect(Collectors.toMap(TimesCountEntity::getId, TimesCountEntity::getTimes));
    }
张辰's avatar
张辰 committed
127
}