ny
昨天 b6f169fe43a2b13f351aefc152374fc7f0bc8cb7
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
package jnpf.base.mapper;
 
 
import cn.hutool.core.util.ObjectUtil;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import jnpf.base.entity.CommonWordsEntity;
import jnpf.util.StringUtil;
import jnpf.util.UserProvider;
 
import java.util.List;
import java.util.Objects;
 
/**
 * 审批常用语
 *
 * @author JNPF开发平台组 YanYu
 * @version v3.4.6
 * @copyrignt 引迈信息技术有限公司
 * @date 2023-01-06
 */
public interface CommonWordsMapper extends SuperMapper<CommonWordsEntity> {
 
    default List<CommonWordsEntity> getListModel(String type) {
        QueryWrapper<CommonWordsEntity> query = new QueryWrapper<>();
        query.lambda().eq(CommonWordsEntity::getEnabledMark, 1)
                .and(t ->
                        t.and(t2 -> t2.eq(CommonWordsEntity::getCreatorUserId, UserProvider.getUser().getUserId()).or().eq(CommonWordsEntity::getCommonWordsType, 0))
                );
        // 排序
        query.lambda()
                .orderByDesc(CommonWordsEntity::getCommonWordsType)
                .orderByDesc(CommonWordsEntity::getUsesNum)
                .orderByAsc(CommonWordsEntity::getSortCode)
                .orderByDesc(CommonWordsEntity::getCreatorTime);
        return this.selectList(query);
    }
 
    default Boolean existSystem(String systemId) {
        QueryWrapper<CommonWordsEntity> query = new QueryWrapper<>();
        query.lambda().like(CommonWordsEntity::getSystemIds, systemId);
        return selectCount(query) > 0;
    }
 
    default Boolean existCommonWord(String id, String commonWordsText, Integer commonWordsType) {
        QueryWrapper<CommonWordsEntity> query = new QueryWrapper<>();
        if (StringUtil.isNotEmpty(id)) {
            query.lambda().ne(CommonWordsEntity::getId, id);
        }
        if (ObjectUtil.isNotEmpty(commonWordsType)) {
            if (Objects.equals(commonWordsType, 1)) {
                query.lambda().and(t ->
                        t.eq(CommonWordsEntity::getCreatorUserId, UserProvider.getUser().getUserId()).or().eq(CommonWordsEntity::getCommonWordsType, 0)
                );
            } else {
                query.lambda().eq(CommonWordsEntity::getCommonWordsType, commonWordsType);
            }
        }
        query.lambda().eq(CommonWordsEntity::getCommonWordsText, commonWordsText);
        return selectCount(query) > 0;
    }
 
    default void addCommonWordsNum(String commonWordsText) {
        QueryWrapper<CommonWordsEntity> query = new QueryWrapper<>();
        query.lambda().eq(CommonWordsEntity::getCommonWordsText, commonWordsText);
        query.lambda().eq(CommonWordsEntity::getCreatorUserId, UserProvider.getUser().getUserId());
        query.lambda().eq(CommonWordsEntity::getCommonWordsType, 1);
        List<CommonWordsEntity> list = selectList(query);
        if (list.size() > 0) {
            for (CommonWordsEntity item : list) {
                long num = item.getUsesNum() == null ? 0 : item.getUsesNum();
                item.setUsesNum(num + 1);
                this.updateById(item);
            }
        }
    }
}