由于小程序是微信静默登录,统计小程序的登录次数就显得尤为棘手,方案是查日志表的信息,统计用户当天首次访问页面,有就作为当天登录次数,总和为总登录次数,统计月活和近三月登录次数
简单实现,有重复的代码,可以拿着优化一下再用
//每天登录次数
int dayCount = 0;
//今年总登录次数
int totalCount = 0;
//每天
Map<String, List<UserLog>> collect =
loginDto.getRows().stream().filter(o -> o.getUserId().equals(param.getUserKey())).collect(Collectors.groupingBy(o -> new SimpleDateFormat("yyyy-MM-dd").format(o.getCreateTime())));
//每月
Map<String, List<UserLog>> MounthCollect =
loginDto.getRows().stream().filter(o -> o.getUserId().equals(param.getUserKey())).collect(Collectors.groupingBy(o -> new SimpleDateFormat("yyyy-MM").format(o.getCreateTime())));
//每年(没用到)
// Map<String, List<UserLog>> yearCollect =loginDto.getRows().stream().filter(o -> o.getUserId().equals(param.getUserKey())).collect(Collectors.groupingBy(o -> new SimpleDateFormat("yyyy").format(new Date())));
for (Map.Entry<String, List<UserLog>> month : MounthCollect.entrySet()) {
for (Map.Entry<String, List<UserLog>> stringListEntry : collect.entrySet()) {
List<UserLog> value = stringListEntry.getValue();
String key = stringListEntry.getKey();
dayCount++;
}
totalCount+=dayCount;
}
List<String> dateList1 = new ArrayList<>();
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM");
//获取->最近三个月
for (int j=-1;j>-4;j--){
Calendar calendar = Calendar.getInstance();
calendar.add(Calendar.MONTH,j);
dateList1.add(simpleDateFormat.format(calendar.getTime()));
}
dateList1.forEach(e -> System.out.println(e));
List<String> dateList2 = new ArrayList<>();
SimpleDateFormat simpleDateFormat2 = new SimpleDateFormat("yyyy-MM-dd");
ArrayList<Integer> list1 = new ArrayList<>();
//获取->近三个月的每一天
for (int j=-1;j>-4;j--){
Calendar calendar = Calendar.getInstance();
//年份
int year = calendar.get(Calendar.YEAR);
calendar.add(Calendar.MONTH,j);
String format = simpleDateFormat.format(calendar.getTime());
String dateStr ;
int day = calendar.getActualMaximum(Calendar.DAY_OF_MONTH);
for (int i = 1; i <= day; i++) {
String dayStr;
if (i<10){
dayStr="0"+i;
}else {
dayStr=String.valueOf(i);
}
dateStr=format+"-"+dayStr;
dateList2.add(dateStr);
list1.add(i);
}
}
list1.forEach(o-> System.out.println(o));
dateList2.forEach(e -> System.out.println(e));
//近三个月的总登录次数
int k = 0;
//近三月的月活
int threeCount=0;
for (String s1 : dateList2) {
Map<String, List<UserLog>> collect2 = loginDto.getRows().stream().filter(o -> o.getUserId().equals(param.getUserKey())).collect(Collectors.groupingBy(o -> s1));
for (Map.Entry<String, List<UserLog>> b : collect2.entrySet()) {
List<UserLog> value = b.getValue();
String key = b.getKey();
if (StringUtils.isNotBlank(key)&&CollectionUtils.isNotEmpty(value)){
k++;
}
}
}
threeCount+=k;
Double aDouble = Double.valueOf(threeCount);
int i = Integer.parseInt(new DecimalFormat("0").format(aDouble/3));
userListVo.setMiniAppAverageMonthlyLiving(i);