package com.laker.admin.module.ext.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.laker.admin.module.ext.entity.ExtLog;
import com.laker.admin.module.ext.vo.LogStatisticsTop10Vo;
import com.laker.admin.module.ext.vo.LogStatisticsVo;
import org.apache.ibatis.annotations.Select;
import java.util.List;
/**
*
* 日志 Mapper 接口
*
*
* @author laker
* @since 2021-08-16
*/
public interface ExtLogMapper extends BaseMapper {
@Select("select DATE_FORMAT(create_time,'%Y-%m-%d') date,count(*) value from ext_log where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= create_time group by date ORDER BY create_time ")
List selectStatistics7Day();
@Select("SELECT\n" +
"\tw.ip,\n" +
"\tcity,\n" +
"\tcount( * ) \n" +
"\tVALUE\t\n" +
"FROM\n" +
"\text_log w \n" +
"WHERE\n" +
"\tDATE_SUB( CURDATE( ), INTERVAL 1 day ) <= w.create_time \n" +
"GROUP BY\n" +
"\tw.ip \n" +
"ORDER BY\n" +
"\t\n" +
"VALUE\n" +
"DESC \n" +
"LIMIT 10")
List selectStatisticsVisitsTop10IP();
@Select("SELECT count(DISTINCT ip) from ext_log")
int selectDistinctIp();
}