From c635d78b479510ebe2556a420948effcd30a0731 Mon Sep 17 00:00:00 2001 From: skyouc Date: 星期六, 21 十二月 2024 18:40:43 +0800 Subject: [PATCH] 新建德森项目分支 --- zy-asrs-common/src/main/java/com/zy/asrs/common/sys/mapper/OperateLogMapper.java | 52 ++++++++++++++++++++++++++-------------------------- 1 files changed, 26 insertions(+), 26 deletions(-) diff --git a/zy-asrs-common/src/main/java/com/zy/asrs/common/sys/mapper/OperateLogMapper.java b/zy-asrs-common/src/main/java/com/zy/asrs/common/sys/mapper/OperateLogMapper.java index f160c67..1c4373d 100644 --- a/zy-asrs-common/src/main/java/com/zy/asrs/common/sys/mapper/OperateLogMapper.java +++ b/zy-asrs-common/src/main/java/com/zy/asrs/common/sys/mapper/OperateLogMapper.java @@ -1,26 +1,26 @@ -package com.zy.asrs.common.sys.mapper; - -import com.baomidou.mybatisplus.core.mapper.BaseMapper; -import com.zy.asrs.common.sys.entity.OperateLog; -import org.apache.ibatis.annotations.Mapper; -import org.apache.ibatis.annotations.Param; -import org.apache.ibatis.annotations.Select; -import org.springframework.stereotype.Repository; - -import java.util.List; -import java.util.Map; - -@Mapper -@Repository -public interface OperateLogMapper extends BaseMapper<OperateLog> { - - @Select("select count(1) from sys_operate_log where yearweek(date_format(create_time,'%Y-%m-%d')) = yearweek(now());") - int selectCountByCurrentWeek(); - - @Select("select MONTH(create_time) as node , count(1) as val from sys_operate_log where 1 = 1 and year(create_time) = #{year} group by MONTH(create_time)") - List<Map<String, Object>> getReportByYear(@Param("year") Integer year); - - @Select("select DAYOFMONTH(create_time) as node,count(1) as val from sys_operate_log where 1 = 1 and year(create_time) = #{year} and month(create_time) = #{month} group by DAYOFMONTH(create_time)") - List<Map<String, Object>> getReportByMonth(@Param("year") Integer year, @Param("month") Integer month); - -} +package com.zy.asrs.common.sys.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.zy.asrs.common.sys.entity.OperateLog; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; +import org.apache.ibatis.annotations.Select; +import org.springframework.stereotype.Repository; + +import java.util.List; +import java.util.Map; + +@Mapper +@Repository +public interface OperateLogMapper extends BaseMapper<OperateLog> { + + @Select("select count(1) from sys_operate_log where yearweek(date_format(create_time,'%Y-%m-%d')) = yearweek(now());") + int selectCountByCurrentWeek(); + + @Select("select MONTH(create_time) as node , count(1) as val from sys_operate_log where 1 = 1 and year(create_time) = #{year} group by MONTH(create_time)") + List<Map<String, Object>> getReportByYear(@Param("year") Integer year); + + @Select("select DAYOFMONTH(create_time) as node,count(1) as val from sys_operate_log where 1 = 1 and year(create_time) = #{year} and month(create_time) = #{month} group by DAYOFMONTH(create_time)") + List<Map<String, Object>> getReportByMonth(@Param("year") Integer year, @Param("month") Integer month); + +} -- Gitblit v1.9.1