初始化项目

elkers

2025-04-07 2dba8dbb14af4616eec876fd9af744651e8beeda

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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
package com.nanjing.water.repository.impl;
 
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.nanjing.water.common.PagerResult;
import com.nanjing.water.common.enums.EYesOrNo;
import com.nanjing.water.common.util.ListUtil;
import com.nanjing.water.common.util.NumericUtil;
import com.nanjing.water.common.util.StringUtil;
import com.nanjing.water.entity.dto.OrderByDTO;
import com.nanjing.water.entity.dto.SearchBasicDTO;
import com.nanjing.water.entity.enums.EOrderBy;
import com.nanjing.water.entity.search.SearchQuartzTaskInfo;
import com.nanjing.water.repository.BasicMapperImpl;
import com.nanjing.water.repository.mapper.QuartzTaskInfoMapper;
import com.nanjing.water.repository.po.QuartzTaskInfoPO;
import org.springframework.stereotype.Repository;
 
import java.util.List;
 
/**
 * 定时任务信息表
 *
 * @author lin.liu
 * @description 定时任务信息表
 */
@Repository
public class QuartzTaskInfoMapperImpl extends BasicMapperImpl<QuartzTaskInfoPO, QuartzTaskInfoMapper> {
    public QuartzTaskInfoMapperImpl(QuartzTaskInfoMapper mapper) {
        super(mapper);
    }
 
    /**
     * 分页查询
     *
     * @param request 请求参数
     */
    @Override
    public PagerResult<QuartzTaskInfoPO> search(SearchBasicDTO request) {
        // 查询条件类型还原
        SearchQuartzTaskInfo search = (SearchQuartzTaskInfo) request;
 
        LambdaQueryWrapper<QuartzTaskInfoPO> queryWrapper = this.query();
        // 状态非逻辑删除
        queryWrapper.eq(QuartzTaskInfoPO::getIsDelete, EYesOrNo.NO.getValue());
        // 状态
        queryWrapper.eq(NumericUtil.tryParseInt(search.getStatus()).compareTo(0) > 0, QuartzTaskInfoPO::getStatus, search.getStatus());
        // 状态列表
        queryWrapper.in(ListUtil.isNotNullOrEmpty(search.getListStatus()), QuartzTaskInfoPO::getStatus, search.getListStatus());
        // 任务编号
        queryWrapper.eq(StringUtil.isNotNullOrEmpty(search.getTaskNo()), QuartzTaskInfoPO::getTaskNo, search.getTaskNo());
        // 数据创建时间-起始
        queryWrapper.ge(NumericUtil.tryParseLong(search.getCreateTimeStart()).compareTo(0L) > 0, QuartzTaskInfoPO::getCreateTime, search.getCreateTimeStart());
        // 数据创建时间-截止
        queryWrapper.le(NumericUtil.tryParseLong(search.getCreateTimeEnd()).compareTo(0L) > 0, QuartzTaskInfoPO::getCreateTime, search.getCreateTimeEnd());
        // 关键字
        if (StringUtil.isNotNullOrEmpty(search.getKeywords())) {
            queryWrapper.like(QuartzTaskInfoPO::getTaskName, search.getKeywords());
        }
        // 排序处理
        if (ListUtil.isNotNullOrEmpty(search.getOrderBy())) {
            for (OrderByDTO item : search.getOrderBy()) {
                EOrderBy orderBy = EOrderBy.getByValue(item.getOrderBy());
                // 顺序排序
                if (item.getIsAsc()) {
                    switch (orderBy) {
                        // 主键
                        case ID:
                            queryWrapper.orderByAsc(QuartzTaskInfoPO::getId);
                            break;
                        // 数据创建时间
                        case CREATE_TIME:
                            queryWrapper.orderByAsc(QuartzTaskInfoPO::getCreateTime);
                            break;
                        // 最后更新时间
                        case UPDATE_TIME:
                            queryWrapper.orderByAsc(QuartzTaskInfoPO::getUpdateTime);
                            break;
                    }
                } else {
                    // 倒叙排序
                    switch (orderBy) {
                        // 主键
                        case ID:
                            queryWrapper.orderByAsc(QuartzTaskInfoPO::getId);
                            break;
                        // 数据创建时间
                        case CREATE_TIME:
                            queryWrapper.orderByAsc(QuartzTaskInfoPO::getCreateTime);
                            break;
                        // 最后更新时间
                        case UPDATE_TIME:
                            queryWrapper.orderByAsc(QuartzTaskInfoPO::getUpdateTime);
                            break;
                    }
                }
            }
        } else {
            queryWrapper.orderByDesc(QuartzTaskInfoPO::getId);
        }
        Page<QuartzTaskInfoPO> pageResult = DB.selectPage(new Page<>(search.getPage(), search.getLimit()), queryWrapper);
        return new PagerResult<>(pageResult.getSize(), pageResult.getCurrent(), pageResult.getTotal(), pageResult.getRecords());
    }
 
    public List<QuartzTaskInfoPO> list4Status(Integer status) {
        LambdaQueryWrapper<QuartzTaskInfoPO> queryWrapper = this.query();
        // 非逻辑删除
        queryWrapper.eq(QuartzTaskInfoPO::getIsDelete, EYesOrNo.NO.getValue());
        // 状态
        queryWrapper.eq(QuartzTaskInfoPO::getStatus, status);
        return DB.selectList(queryWrapper);
    }
 
    public QuartzTaskInfoPO get4No(String taskNo) {
        LambdaQueryWrapper<QuartzTaskInfoPO> queryWrapper = this.query();
        // 任务编号
        queryWrapper.eq(QuartzTaskInfoPO::getTaskNo, taskNo);
        return DB.selectOne(queryWrapper);
    }
}