// // Source code recreated from a .class file by IntelliJ IDEA // (powered by FernFlower decompiler) // package com.flow.mapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.flow.pojo.Loginjilu; import java.util.List; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; public interface LoginJiLuMapper extends BaseMapper { @Select({"select * from loginjilu where none = 0 ORDER BY LoginDate DESC "}) List findAllLoginJiLu(); @Select({"select * from loginjilu where none = 0 and LoginCompany = #{Zong} ORDER BY LoginDate DESC"}) List findAllLoginJiLuZi(@Param("Zong")String var1); @Select({"select COUNT(*) from loginjilu where to_days(logindate) = to_days(now()) and none = 0"}) String jrfwl(); @Select({"SELECT count(*) FROM loginjilu where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(logindate) and none = 0"}) String bzfwl(); @Select({"SELECT COUNT(*) FROM loginjilu WHERE DATE_FORMAT( logindate, '%Y%m' ) = DATE_FORMAT( CURDATE( ) , '%Y%m' ) and none = 0"}) String byflw(); @Select({"SELECT count(*) from loginjilu where none = 0"}) String zgfwl(); @Select({"SELECT LoginDate FROM `loginjilu` where LoginCompany = #{Zong} ORDER BY LoginDate DESC LIMIT 0 , 1"}) String userdate(String var1); }