From e15f561a1f9eddfde503d59baf45a860b131928e Mon Sep 17 00:00:00 2001
From: fei.wang <wf18701153496@163.com>
Date: 星期三, 13 八月 2025 14:22:50 +0800
Subject: [PATCH] 更新最新版代码
---
src/main/java/com/flow/mapper/CardMapper.java | 20 +++++++++++++++++++-
1 files changed, 19 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/flow/mapper/CardMapper.java b/src/main/java/com/flow/mapper/CardMapper.java
index 63fa27f..299e7f8 100644
--- a/src/main/java/com/flow/mapper/CardMapper.java
+++ b/src/main/java/com/flow/mapper/CardMapper.java
@@ -8,17 +8,35 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.flow.pojo.Card;
import java.util.List;
+
+import com.flow.pojo.Company;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
public interface CardMapper extends BaseMapper<Card> {
+ @Select({"select * from card where none = 0 and entryclerk = #{entry} ORDER BY enterdate DESC"})
+ List<Card> findAllUsers(String var1);
+
@Select({"select * from card where none = 0 ORDER BY enterdate DESC"})
- List<Card> findAllUsers();
+ List<Card> findAllUsers2();
@Select({"select * from card where none = 0 and company = #{Zong} ORDER BY enterdate DESC"})
List<Card> findAllUsersZi(@Param("Zong")String var1);
+ @Select({"SELECT * FROM card WHERE none = 0 and entryclerk = #{entry} and DATEDIFF(STR_TO_DATE(enddate, '%Y-%m-%d'), CURDATE()) <= 20 and DATEDIFF(STR_TO_DATE(enddate, '%Y-%m-%d'), CURDATE())>0"})
+ List<Card> findAllUsersdaoqi(@Param("entry")String var1);
+
+ @Select({"SELECT * FROM card WHERE none = 0 and DATEDIFF(STR_TO_DATE(enddate, '%Y-%m-%d'), CURDATE()) <= 20 and DATEDIFF(STR_TO_DATE(enddate, '%Y-%m-%d'), CURDATE())>0"})
+ List<Card> findAllUsersdaoqi1();
+
+ @Select({"SELECT * FROM card WHERE none = 0 and company = #{Zong} and DATEDIFF(STR_TO_DATE(enddate, '%Y-%m-%d'), CURDATE()) <= 20 and DATEDIFF(STR_TO_DATE(enddate, '%Y-%m-%d'), CURDATE())>0"})
+ List<Card> findAllUsersdaoqizi(@Param("Zong")String var1);
+
+
+ @Select({"select * from card where none = 0 and company = #{companyabbname} or company = #{companyname} ORDER BY enterdate DESC"})
+ List<Card> findAllcompanycard(@Param("companyname")String companyname,@Param("companyabbname")String companyabbname);
+
@Select({"SELECT COUNT(*) FROM card where none = 0"})
int findCardNum1();
--
Gitblit v1.9.3