逻辑

KKSU

2024-07-09 b90204ae4fc53bf4bdc1c232aa4079e5d3e434f7

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
package cc.mrbird.febs.dapp.mapper;
 
import cc.mrbird.febs.dapp.entity.DappStorage;
import cn.hutool.core.date.DateTime;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
 
import java.util.Date;
import java.util.List;
 
public interface DappStorageMapper extends BaseMapper<DappStorage> {
 
    DappStorage selectOneByDateDesc( @Param("date") Date date);
 
    List<DappStorage> selectListByDateDesc( @Param("date") Date date);
 
    List<DappStorage> selectListByDate( @Param("date") Date date);
 
    DappStorage selectAmountByDesc(@Param("date") Date date,@Param("offset")int offset,@Param("count")int count);
 
    DappStorage selectOneByCreateTimeDesc(@Param("offset")int offset,@Param("count")int count);
 
    List<DappStorage> selectByAmountDesc(@Param("date") Date date,@Param("offset")int offset,@Param("count")int count);
 
    List<DappStorage> selectSumByAmountDesc(@Param("date") Date date,@Param("offset")int offset,@Param("count")int count);
 
    DappStorage selectAmountByAmountDesc(@Param("memberId")Long memberId,@Param("offset")int offset,@Param("count")int count);
 
    IPage<DappStorage> selectListInPage(@Param("record")DappStorage dappStorage, Page<DappStorage> page);
 
    List<DappStorage> selectListGroupByMemberId();
 
    List<DappStorage> selectSumByAmountDescFiveToFive(@Param("startTime")DateTime startTime, @Param("offset")int offset,@Param("count")int count);
}