From 871d4095b07cedacb7fbef4c38d64982f539c404 Mon Sep 17 00:00:00 2001
From: fei.wang <wf18701153496@163.com>
Date: 星期四, 09 五月 2024 15:40:15 +0800
Subject: [PATCH] 测试提交
---
src/main/java/com/flow/mapper/ChongZhMapper.java | 42 ++++++++++++++++++++++++++++++++++++++++++
1 files changed, 42 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/flow/mapper/ChongZhMapper.java b/src/main/java/com/flow/mapper/ChongZhMapper.java
new file mode 100644
index 0000000..addc2f5
--- /dev/null
+++ b/src/main/java/com/flow/mapper/ChongZhMapper.java
@@ -0,0 +1,42 @@
+//
+// 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.Chongzhi;
+import org.apache.ibatis.annotations.Select;
+
+public interface ChongZhMapper extends BaseMapper<Chongzhi> {
+ @Select({"select sum(CzMoney) from chongzhi where to_days(CzDate) = to_days(now()) and none = 0 and Company = #{Zong}"})
+ String jrfwl(String var1);
+
+ @Select({"SELECT sum(CzMoney) FROM chongzhi where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(CzDate) and none = 0 and Company = #{Zong}"})
+ String bzfwl(String var1);
+
+ @Select({"SELECT sum(CzMoney) FROM chongzhi WHERE DATE_FORMAT( CzDate, '%Y%m' ) = DATE_FORMAT( CURDATE( ) , '%Y%m' ) and none = 0 and Company = #{Zong}"})
+ String byflw(String var1);
+
+ @Select({"SELECT sum(CzMoney) from chongzhi where none = 0 and Company = #{Zong}"})
+ String zgfwl(String var1);
+
+ @Select({"select sum(CzMoney) from chongzhi where to_days(CzDate) = to_days(now()) and none = 0 "})
+ String jrfwl1();
+
+ @Select({"SELECT sum(CzMoney) FROM chongzhi where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(CzDate) and none = 0 "})
+ String bzfwl1();
+
+ @Select({"SELECT sum(CzMoney) FROM chongzhi WHERE DATE_FORMAT( CzDate, '%Y%m' ) = DATE_FORMAT( CURDATE( ) , '%Y%m' ) and none = 0 "})
+ String byflw1();
+
+ @Select({"SELECT sum(CzMoney) from chongzhi where none = 0 "})
+ String zgfwl1();
+
+ @Select({"SELECT SUM(CzMoney) FROM chongzhi where none = 0"})
+ String findChongZhiJine();
+
+ @Select({"SELECT SUM(CzMoney) FROM chongzhi where none = 0 and company = #{company}"})
+ String findChongZhiJine1(Chongzhi var1);
+}
--
Gitblit v1.9.3