//
|
// 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<Loginjilu> {
|
@Select({"select * from loginjilu where none = 0 ORDER BY LoginDate DESC "})
|
List<Loginjilu> findAllLoginJiLu();
|
|
@Select({"select * from loginjilu where none = 0 and LoginCompany = #{Zong} ORDER BY LoginDate DESC"})
|
List<Loginjilu> 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);
|
}
|
