SELECT DATE(create_date) AS createdate,COUNT(*) AS total FROM sys_log
WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) < DATE(create_date) AND log_type=0 AND method like '%Login%'
GROUP BY createdate;
//1 构建 一下类型
@Data
public class AppUserChartData {
private Date createdate;
private Integer total;
}
//2
<select id="query7login" resultType="io.ants.modules.app.entity.AppUserChartData">
SELECT DATE(create_date) AS createdate,COUNT(*) AS total FROM sys_log
WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= DATE(create_date) AND log_type=0 AND method like '%Login%'
GROUP BY createdate;
</select>
//3
@Mapper
public interface SysLogDao extends BaseMapper<SysLogEntity> {
/**
* 查询7天内的前台用户登录数据
*
*/
List<Map<String,Object>> query7login();
}
//4
List<Map<String,Object>> app_user_login_7=sysLogDao.query7login();
map.put("app_user_login_7",app_user_login_7);->RESULT:
createdate total
2022-02-10 12
2022-02-11 17
2022-02-12 2
2022-02-14 15
2022-02-15 8
2022-02-16 4