From 19fe5a3d816184549e8ffa011c39f218734da8d5 Mon Sep 17 00:00:00 2001
From: fei.wang <wf18701153496@163.com>
Date: 星期一, 13 五月 2024 17:49:50 +0800
Subject: [PATCH] 更改
---
src/main/java/com/flow/mapper/CardMapper.java | 98 +++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 98 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/flow/mapper/CardMapper.java b/src/main/java/com/flow/mapper/CardMapper.java
new file mode 100644
index 0000000..63fa27f
--- /dev/null
+++ b/src/main/java/com/flow/mapper/CardMapper.java
@@ -0,0 +1,98 @@
+//
+// 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.Card;
+import java.util.List;
+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 ORDER BY enterdate DESC"})
+ List<Card> findAllUsers();
+
+ @Select({"select * from card where none = 0 and company = #{Zong} ORDER BY enterdate DESC"})
+ List<Card> findAllUsersZi(@Param("Zong")String var1);
+
+ @Select({"SELECT COUNT(*) FROM card where none = 0"})
+ int findCardNum1();
+
+ @Select({"SELECT count(*) FROM card WHERE DATE_FORMAT (enddate, '%Y%m') = DATE_FORMAT(CURDATE(), '%Y%m') AND none = 0"})
+ int findCardNum2();
+
+ @Select({"SELECT count(*) FROM card WHERE YEAR(enddate)=YEAR(NOW()) and DATE_FORMAT (enddate, '%Y%m') = DATE_FORMAT(CURDATE(), '%Y%m') AND none = 0"})
+ int findCardNum3();
+
+ @Select({"SELECT count(*) FROM card WHERE syflow = '0' and none = 0"})
+ int findCardNum4();
+
+ @Select({"SELECT count(*) FROM card WHERE syflow < '2000' and none = 0"})
+ int findCardNum5();
+
+ @Select({"SELECT COUNT(*) FROM card where none = 0 and company = #{zi} "})
+ int findCardNum1z(String var1);
+
+ @Select({"SELECT count(*) FROM card WHERE DATE_FORMAT (enddate, '%Y%m') = DATE_FORMAT(CURDATE(), '%Y%m') AND none = 0 and company = #{zi}"})
+ int findCardNum2z(String var1);
+
+ @Select({"SELECT count(*) FROM card WHERE YEAR(enddate)=YEAR(NOW()) and DATE_FORMAT (enddate, '%Y%m') = DATE_FORMAT(CURDATE(), '%Y%m') AND none = 0 and company = #{zi}"})
+ int findCardNum3z(String var1);
+
+ @Select({"SELECT count(*) FROM card WHERE syflow = '0G' and none = 0 and company = #{zi}"})
+ int findCardNum4z(String var1);
+
+ @Select({"SELECT count(*) FROM card WHERE syflow < '2G' and none = 0 and company = #{zi}"})
+ int findCardNum5z(String var1);
+
+ @Select({"SELECT * FROM card WHERE none = 0 and cardnumber LIKE CONCAT('%', #{number}, '%') and company = #{company} ORDER BY enterdate DESC"})
+ List<Card> FindSearch(@Param("number") String var1, @Param("company") String var2);
+
+ @Select({"SELECT * FROM card WHERE none = 0 and cardnumber LIKE CONCAT('%', #{number}, '%') ORDER BY enterdate DESC"})
+ List<Card> FindSearch1(@Param("number") String var1);
+
+ @Update({
+ "<script>",
+ "UPDATE card",
+ "<set>",
+ "<foreach item='item' collection='list' separator=','>",
+ "carddate = #{item.carddate},",
+ "enddate = #{item.enddate},",
+ "unitprice = #{item.unitprice},",
+ "enterdate = #{item.enterdate}",
+// "...", // 鏇村鐨勫瓧娈垫洿鏂拌鍙�
+ "</foreach>",
+ "</set>",
+ "WHERE num IN",
+ "<foreach item='item' collection='list' open='(' separator=',' close=')'>",
+ "#{item.num}",
+ "</foreach>",
+ "</script>"
+ })
+ int updateBatchById(List<Card> list);
+
+ @Update({
+ "<script>",
+ "UPDATE card",
+ "<set>",
+ "<foreach item='item' collection='list' separator=','>",
+ "rechargedate = #{item.rechargedate},",
+ "rechargemoney = #{item.rechargemoney},",
+ "enddate = #{item.enddate},",
+ "remainingdays = #{item.remainingdays},",
+ "enterdate = #{item.rechargedate}",
+// "...", // 鏇村鐨勫瓧娈垫洿鏂拌鍙�
+ "</foreach>",
+ "</set>",
+ "WHERE num IN",
+ "<foreach item='item' collection='list' open='(' separator=',' close=')'>",
+ "#{item.num}",
+ "</foreach>",
+ "</script>"
+ })
+ int updateBatchByIdcz(List<Card> list);
+}
--
Gitblit v1.9.3