//
|
// 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;
|
|
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(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} OR notes LIKE CONCAT('%', #{notes}, '%')"})
|
List<Card> FindSearch(@Param("number") String var1, @Param("company") String var2, @Param("notes") String var3);
|
|
@Select({"SELECT * FROM card WHERE none = 0 and cardnumber LIKE CONCAT('%', #{number}, '%') OR notes LIKE CONCAT('%', #{notes}, '%')"})
|
List<Card> FindSearch1(@Param("number") String var1, @Param("notes") String var3);
|
}
|