From b9b58b9ef261cb290d93465f88a2cbd814b576f0 Mon Sep 17 00:00:00 2001
From: fei.wang <wf18701153496@163.com>
Date: 星期一, 13 五月 2024 17:51:44 +0800
Subject: [PATCH] 更改
---
src/main/java/com/flow/mapper/LoginJiLuMapper.java | 36 ++++++++++++++++++++++++++++++++++++
1 files changed, 36 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/flow/mapper/LoginJiLuMapper.java b/src/main/java/com/flow/mapper/LoginJiLuMapper.java
new file mode 100644
index 0000000..5da21c4
--- /dev/null
+++ b/src/main/java/com/flow/mapper/LoginJiLuMapper.java
@@ -0,0 +1,36 @@
+//
+// 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);
+}
--
Gitblit v1.9.3